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 a trigger in mysql? : Sql dba

1128

What is not equal in sql?

1082

what is view? : Sql dba

937

What is consistency?

1105

What are the disadvantages of file system?

1232

how many sql ddl commands are supported by 'mysql'? : Sql dba

1000

How do I write a cron which will run a sql query and mail the results to agroup?

955

What is a field in a database?

1043

What is data type in database?

969

What is output spooling in sql*plus?

1015

What is the starting oracle error number?

1035

How many triggers can be applied to a table?

1037

How many joins in sql?

980

Can a primary key be a foreign key?

1005

Where not exists in sql?

963