数据库sql,该怎么处理

数据库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