不能用max哈 如果我limit1,2不是不管用了。。 select * from dede_archives where FROM_UNIXTIME(pubdate,'%Y-%m-%d') = (select FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by pubdate desc limit 1,2);
date_format(FROM_UNIXTIME(pubdate),'%Y-%m-%d')
select * from dede_archives where FROM_UNIXTIME(pubdate,'%Y-%m-%d') = (select FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by pubdate desc limit 1,1);limit 1,2 是取两个 要不就换成inlimit 1,1 才是取一个,不过取的是第2个limit 0,1 才是取排序的第一个
不能用max哈
如果我limit1,2不是不管用了。。
select * from dede_archives where FROM_UNIXTIME(pubdate,'%Y-%m-%d') = (select FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by pubdate desc limit 1,2);