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 what is an index?

994

Write a sql query to get the third highest salary of an employee from employee_table?

1026

What is before trigger?

943

How to write html code in pl sql?

1050

Explain architecture of sql server notification services?

981

How can I tell if sql is running?

988

Explain what is rdbms?

990

How can you fetch first 5 characters of the string?

945

Is progress software supports to ( pl/sql )?

966

how is myisam table stored? : Sql dba

993

What do you understand by pl/sql packages?

1016

Can instead of triggers be used to fire once for each statement on a view?

894

What is optimistic concurrency control? : Transact sql

939

Does a primary key have to be a number?

915

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

989