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

How many row comparison operators are used while working with a subquery?

543

what is a control file ? : Sql dba

584

What is group by in sql?

553

What is pl sql and why it is used for?

580

Can you have more than one key in a database?

518

What is the difference between inner join and natural join?

515

How can we link a sql database to an existing android app?

550

Which one is faster ienumerable or iqueryable?

491

What is difference between group by and partition by?

502

What is execution plan in sql?

552

Explain the uses of a database trigger?

579

what is the difference between cluster and non cluster index? : Sql dba

564

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1718

What is full form of rtm?

539

What is the usage of sql functions?

555