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 clustered and non-clustered indexes?

1029

What are its different types of dbms?

957

What's the difference between inner join and left join?

949

What are the types of dbms?

922

What are character functions?

1043

What is cascade in sql?

916

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

1028

How do rank () and dense_rank () differ?

977

Which command is used to delete a trigger?

1262

How do you modify a column in sql?

943

What are sql built in functions?

896

Is trigger a stored procedure?

887

What is pl sql collection?

921

What is duration in sql profiler trace?

1022

How do you bind variables in pl sql?

1036