Friday, February 25, 2011

How to get top n Record in Oracle like Sql

Sample Query to get Top n Record from oracle

Select * from tableName where FiledName =”” and rownum<=5

Above statement will give u top 5 record
rownum<=5

No comments:

Post a Comment