Wednesday, 29 January 2014

ORACLE - SQL Query - 3

Query to display first n records of the table

Structure and data of the table i used

 query to display first n records of the table. where &n is a substitution variable in oracle, whose values can be assigned at runtime, very much similar to scanf function in C language

rownum column i used here is a pseudo-column supplied from oracle with every table that you create. Be sure with the behaviour of rownum. check the below queries to understand the behaviour

No comments:

Post a Comment