三种数据库查询指定记录数

Oracle:  select * from country where rownum<=10

sql server: select top 10 * from country

mysql : select * from country limit 10