Oracle,MySQL,Access,Sybase数据库查询第一条记录和前n条记录

总结一下自己接触到的数据库查询第一条和前n条记录的查询方法,希望百度搜索引擎能检索到我的内容,方便大家指正和了解,哈哈！

ps:

以前10条为例:

Sybase/Access数据库查询第一条和前n条记录:
select top 1 * from departments oreder by department_id;
select top 10 * from departments oreder by department_id;


Mysql数据库查询第一条和前n条记录:
select * from table_name order by tb_column desc limit 1;
select * from table_name order by tb_column desc LIMIT 1,10; -- 10 recds


Oracle数据库查询第一条和前n条记录:


select department_id from departments where rownum = 1;


select k.department_id from (
  select department_id, rownum rn from (
         select tmp_dept.department_id from departments tmp_dept
         order by department_id desc
  )
)k
where rn = 10;