SELECT * FROM(SELECT a.*,row_number() over(ORDER BY NULL) rn FROM emp a)

how to retrive only second row from table?

Question Posted / monika

Answer Posted / monika

SELECT * FROM(SELECT a.*,row_number() over(ORDER BY NULL)
rn FROM emp a)
WHERE rn=2

Is This Answer Correct ?

18 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What port does sql server use?

1112

what are different types of keys in sql?

1220

What are expressions?

1062

How to change the order of columns in Oracle SQL Plus ?

1102

Why do we need unique key in a table?

1005

What is a pl/sql block?

1329

What is the use of primary key?

1049

what is a unique key ? : Sql dba

1149

What is coalesce sql?

1056

What is the maximum number of columns in sql table?

1229

What is the advantage of nosql?

1113

What is the difference between the conventional and direct path loads? : aql loader

1473

How is sql used in oracle?

1037

What are pl/sql packages?

1158

What does where 1 1 mean in sql?

1077