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 is table? : Sql dba

993

What is the difference between inner join and outer join?

931

What is mutating sql table?

1040

How many types of index are there?

962

How to rename a column in the output of sql query?

1005

What is the main difference between sql and pl/sql?

1028

How to display the records between two range in Oracle SQL Plus?

1101

Can we use ddl statements in stored procedure?

1097

how to delete an existing column in a table? : Sql dba

954

Is it possible to pass parameters to triggers?

1032

Why is sql better than hql?

920

What is the use of count (*) in sql?

983

Which sorts rows in sql?

970

What company owns postgresql?

963

How do you explain an index?

1224