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

What is ttitle and btitle?

1047

Does oracle use sql?

907

Is sql a oracle?

950

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1129

what is query cache in mysql? : Sql dba

1015

Does access use sql?

1018

What is difference between rank () row_number () and dense_rank () in sql?

1089

Can you skip header records while loading? : aql loader

1018

What is sql in oracle?

1043

Which are the different character-manipulation functions in sql?

1038

what are string data types? : Sql dba

1023

What is embedded sql with example?

1018

Can we use update in sql function?

1045

What is t-sql? : Transact sql

967

What is fmtonly in sql?

1059