mysql与oracle得到前几条数据

mysql与oracle得到前几条数据

select * from organization  order by id desc LIMIT 3(mysql)    LIMIT 关键字

   

    select * from organization  where rownum<4 order by id (oracle)    rownum  关键字