how I can first recordt from select query.
I have some table t1 with 100 records and if I type "select * from t1" I have 100 records .. How I can get just first record without "where" ... ?
Leave a comment...
- 1 Comments
- select *
where rownum = 1;
Rownum is a psudo column numbered sequentially for each row in the resultset.
If you wanted the first 10 rows it would be...
where rownum <= 10;#1; Sun, 24 Feb 2008 11:14:00 GMT