SELECT DISTINCT(datetime),id FROM `user` GROUP BY datetime ORDER BY datetime LIMIT 3
哦,是这样的要求 按理说,用 select * from user where datetime in (select datetime from user order by datetime desc limit 3) 就可以了 但mysql并不支持子查询,所以要 caeate temporara table temp select datetime from user order by datetime desc limit 3 select user.* from user,temp where user.datetime=temp.datetime分做两步走
现在需要将字段datetime为200312,200311,200303的所有记录都显示出来
按理说,用
select * from user where datetime in (select datetime from user order by datetime desc limit 3)
就可以了
但mysql并不支持子查询,所以要
caeate temporara table temp select datetime from user order by datetime desc limit 3
select user.* from user,temp where user.datetime=temp.datetime分做两步走