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

Which command is used to call a stored procedure?

1055

What is tuple in sql?

1143

what are date and time functions in mysql? : Sql dba

1028

What is procedure and function?

1035

What is a left join?

1008

what is log shipping? : Sql dba

1167

What is sql character function?

1151

What are three advantages to using sql?

1071

What are the types of records?

1038

How is sql used in oracle?

1039

what is 'mysqladmin' in mysql? : Sql dba

1076

explain normalization concept? : Sql dba

1090

What is the reports view in oracle sql developer?

1045

Which is faster union or join?

1027

What is constant in pl sql?

1063