You can get first n rows by using "rownum" pseudocolumn. Select * from (select * from table_name order by field_name ) where rownum <= n if you want to get fields having bigger values change the order by clause like that "order by field_name desc" HTH Mustafa OCAK PHP Developer Ankara, Turkey ----- Original Message ----- From: "Hendri" <c4c3m@myrealbox.com> To: <php-db@lists.php.net> Sent: Monday, April 21, 2003 11:08 AM Subject: Select from lastrow > Hi, DB-Developers. > I want to ask something about SELECT Query on Oracle. > how can i get sorted row from the table (in MySQL, LIMIT ) > and how does if i wanted the lastrow or the firstrow. > > Thanks > -- > Hendri 'cacem' > Hobbyst Programmer > , > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
