SELECT * FROM t1 a WHERE 5 = (SELECT COUNT(rowid) FROM t1

how to find 5th row ?

Question Posted / suresh babu

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between sql and mysql.

1041

what are the authentication modes in sql server? : Sql dba

1044

What are hotfixes and patches?

930

How do I run a sql trace?

946

What are sql*plus environment variables?

1075

how to show all tables with 'mysql'? : Sql dba

1093

What is normalisation in sql?

1041

What is pl sql variable?

962

How to check if a column is nullable before setting to nullable?

1104

What is online transaction processing (oltp)?

1004

What are the packages in pl sql?

1000

Why we use joins in sql?

965

Why do we need a foreign key?

1074

What are the types of sql commands?

1075

Explain two easy sql optimizations.

995