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 ?

25 Yes

10 No

Please Help Members By Posting Answers For Below Questions

explain what is mysql? : Sql dba

580

How to download oracle sql developer?

650

Explain exception handling in pl/sql?

517

Can you load data into multiple tables at once? : aql loader

587

Which one is faster ienumerable or iqueryable?

469

What are the parts of a sql statement?

538

When is a declare statement required?

656

What is clause in sql?

569

what is a record in a database ? : Sql dba

557

How long will it take to learn pl sql?

509

What jobs use sql?

512

How do you declare a constant?

511

What is join view in sql?

499

Can we insert delete data in view?

528

define sql update statement ? : Sql dba

556