open forum
flipkart
all technical questions are discussed here.
Pages
Home
About
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment