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

what is meant by urlencode and urldocode? : Sql dba

598


How many types of relationship are there?

545


What are transaction and its controls?

557


Is it possible to pass parameters to triggers?

570


Why procedure is used in sql?

529






Why do we use sql constraints? Which constraints we can use while creating database in sql?

543


How can you save or place your msg in a table?

521


what are different types of collation sensitivity? : Sql dba

549


Explain lock escalation? : Transact sql

702


how is exception handling handled in mysql? : Sql dba

549


What is a crud api?

493


How to run sql functions in pl/sql?

534


Where is all the data on the internet stored?

552


what are string data types? : Sql dba

510


Can we create foreign key without primary key?

530