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

Cite the differences between execution of triggers and stored procedures?

1081

How do you add a column to a table?

1056

Can we create a trigger on view?

901

What is normalization sql?

1063

Why do we need cursor in pl sql?

1138

what are different types of collation sensitivity? : Sql dba

1070

What does count (*) mean?

936

How many joins can you have in sql?

939

Define commit?

1009

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1167

Explain the the update statement in sql?

1042

how to use in conditions? : Sql dba

1014

How many types of privileges are available in sql?

1350

what does the t-sql command ident_current does? : Transact sql

984

What is the maximum rows in csv?

927