红联Linux门户
Linux帮助

mysql与oracle得到前几条数据

发布时间:2006-10-18 21:44:09来源:红联作者:Innovation
select * from organization order by id desc LIMIT 3(mysql) LIMIT 关键字



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

共有 1 条评论

  1. xiangcj 于 2007-06-16 13:31:14发表:

    :0)1 :0D1 :mad:1 :0Q :victory: :ha3nd :handshake :49ab:1 :77ab:1 :0L