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 are the different types of a subquery?

980

How to take user input in pl sql?

1105

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

968

How many types of keys are there in sql?

985

What is before and after trigger?

889

Does db2 use sql?

888

Enlist the advantages of sql.

937

What is basic structure of pl sql?

985

What is an index in sql with example?

918

Does mysql_real_escape_string prevent sql injection?

906

How many columns should be in an index?

901

How to Declare Fixed Length String Value In PL SQL

1101

What are the different datatypes available in PL/SQL?

1027

How will you distinguish a global variable with a local variable in pl/sql?

1090

How many sql commands are there?

1070