all technical questions are discussed here.
Monday, July 29, 2013
How to display first k rows in SQL
To display first k rows from a table make use of rownum keyword which initially has value 0 and gets incremented by one when it moves to next row.
Here is the example to display first three rows from emp table.
select *from emp where rownum < 4
Share to Twitter
Share to Facebook
Share to Pinterest
Post Comments (Atom)