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

What is not null in sql?

1061

What is sql key?

998

what is online transaction processing (oltp)? : Sql dba

999

Which nosql database is best?

982

Define implicit and explicit cursors.

1150

What is the difference between joins?

1045

Explain correlated query work?

1059

What is oracle sql developer?

1061

What is a dirty read sql?

1149

what is the difference between a having clause and a where clause? : Sql dba

1087

how do you control the max size of a heap table? : Sql dba

982

Why truncate is faster than delete?

1114

What is raw datatype in sql?

1048

What are the types of keys?

997

how to include character strings in sql statements? : Sql dba

1077