1. select * from emp e1 where 5 =( select count(rowid) from emp e2 where

how to find 5th row ?

Question Posted / alok narayan

Answer Posted / alok narayan

1.
select * from emp e1 where 5 =( select count(rowid) from
emp e2 where e1.rowid >= e2.rowid) ;

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can we optimize a sql query?

580

Does sqlite need a server?

546

Can dml statements be used in pl/sql?

585

What is identity column in sql server?

539

What are user defined functions?

586

how to check server status with 'mysqladmin'? : Sql dba

577

What is the difference between inner join and natural join?

517

How do you copy a table in sql?

570

what are date and time intervals? : Sql dba

569

Is mariadb a nosql database?

548

Can you join views in sql?

550

what is an extent ? : Sql dba

586

Is pl sql useful?

545

How global cursor can be declare with dynamic trigger ?

1756

how to return query output in html format? : Sql dba

657