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

How many postgresql users are there, worldwide?

672


What is a behavioral trigger?

604


What is varchar example?

662


How do I save a stored procedure?

618


what are the non-standard sql commands supported by 'mysql'? : Sql dba

664






Are null values same as that of zero or a blank space?

643


What are different functions in sql?

605


what is the bond code in materialized view?

2583


What is left join example?

592


What language is oracle sql developer?

619


what is not null constraint? : Sql dba

633


What is data definition language?

705


What are the three pl sql block types?

651


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

916


Is it possible to link two groups inside a cross products after the cross products group has been created?

685