SELECT * FROM emp a WHERE 2 = (SELECT COUNT(rowid) FROM emp b WHERE a.r

how to retrive only second row from table?

Question Posted / umadevi

Answer Posted / umadevi

SELECT * FROM emp a WHERE 2 = (SELECT COUNT(rowid) FROM
emp b WHERE a.rowid >= b.rowid)

now it will work. instead of :n we have mention row number.

Is This Answer Correct ?

26 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Does user triggers have entry for trigger with compilation errors?

1034

how to include comments in sql statements? : Sql dba

953

Why is nosql good?

1023

What is audit logout in sql profiler?

1022

What is the trigger in sql?

947

What are the differences between implicit and explicit cursors?

1065

What are the methods of filing?

935

What is dynamic query?

969

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1065

What is the use of index in hive?

1003

What is transaction control language (tcl)?

1133

what is difference between delete and truncate commands? : Sql dba

1127

Can we change the table name in sql?

938

How does cross join work?

948

What is execution plan in sql?

1041