how to find 5th row ?

Answer Posted / suresh babu

SELECT * FROM t1 a
WHERE 5 = (SELECT COUNT(rowid)
FROM t1 b
WHERE a.rowid >= b.rowid);

This Query,Which is used to find 5 record from Table.

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a procedure in a package be overloaded?

749


how can we destroy the cookie? : Sql dba

736


How do you create a db file?

708


How to run pl sql program in mysql?

678


How do we use distinct statement? What is its use?

748






what are the types of join and explain each? : Sql dba

761


How do I run pl sql in sql developer?

847


Can a composite key be null?

710


What is pessimistic concurrency control? : Transact sql

831


Can you have more than one trigger on a table?

704


Is nosql faster than sql?

743


How many types of privileges are available in sql?

960


What is foreign key in sql with example?

678


How many types of normalization are there?

662


What packages are available to pl/sql developers?

805