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

What is the difference between a primary key and a clustered index?

697

What is a join query?

722

How to avoid duplicate records in a query?

747

Is sql considered coding?

758

What is the most restrictive isolation level? : Transact sql

768

Which are the different case manipulation functions in sql?

734

What are different types of functions in sql?

723

What are the types of sql commands?

741

What is package in pl sql with an examples?

728

How many joins can you have in sql?

687

What is rollback?

786

Explain the difference in execution of triggers and stored procedures?

748

What is coalesce in sql?

732

How can we solve sql error: ora-00904: invalid identifier?

884

what is the difference between primary key and unique key? : Sql dba

705