select * from ( select ROW_NUMBER() OVER (ORDER BY alias) as rowid ,alia

how to retrive only second row from table?

Question Posted / shince jose

Answer Posted / shince jose

select * from (

select ROW_NUMBER() OVER (ORDER BY alias) as rowid ,alias

from tbl) a where rowid=2.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are different types of collation sensitivity? : Sql dba

546

How to display Row Number with Records in Oracle SQL Plus?

584

what is timestamp in mysql? : Sql dba

557

Is progress software supports to ( pl/sql )?

520

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

660

Can you upgrade sql express to full sql?

506

What is a crud api?

491

How many types of privileges are available in sql?

729

Explain clause in sql?

552

What is triggering circuit?

588

What is primary key and unique key?

536

What is the purpose of the partition table?

538

What does trigger mean in slang?

517

Explain the rollback statement?

570

What operators deal with null?

601