数据库sql
怎么查A表内离系统时间最近的记录，一条记录可以用rownum，多条呢；
select * from (select * from A a where a.name = 1 and oder by create_date desc)where rownum = 1;
只查记录1的话用这个，那么要查记录1，2 怎么办
[解决办法]
in或者or
[解决办法]
select top 1 * from A a where a.name in(1,2) order by create_date desc
[解决办法]
select rownum,A.* from A a where A.name = 1
where rownum <= n
oder by create_date desc
[解决办法]
--mssql-- Top [要显示的记录数]
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
