怎么查A表内离系统时间最近的记录,一条记录可以用rownum,多条呢;
select * from (select * from A a where a.name = 1 and oder by create_date desc)where rownum = 1;
只查记录1的话用这个,那么要查记录1,2 怎么办
select * from (select * from A a where a.name = 1 and oder by create_date desc)where rownum = 1;
只查记录1的话用这个,那么要查记录1,2 怎么办
where rownum <= n
oder by create_date desc
select top 1 * from A where name = 1 and oder by create_date desc--mysql
select * from A where name = 1 and oder by create_date desc limit 0, 1
select top 1 * from A where name = 1 and oder by create_date desc--mysql limit 0, [要显示的记录数]
select * from A where name = 1 and oder by create_date desc limit 0, 1