how to retrive only second row from table?

Answer Posted / naresh raju

select * from emp where rownum<=2
minus
select * from emp where rownum<2

Is This Answer Correct ?    63 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I send sql query results to excel?

581


Why coalesce is used in sql?

473


What does fetching a cursor do?

617


Does varchar need length?

520


What are packages in pl sql and also explain its advantages?

534






What are types of indexes in sql?

539


What are the sql versions?

522


What is difference between rank () row_number () and dense_rank () in sql?

581


Is it possible to create startup or shutdown trigger for on-schema?

587


Is coalesce faster than isnull?

512


What is the purpose of primary key?

535


What program will open a mdb file?

503


What's the difference between a primary key and a clustered index?

518


Why use subqueries instead of joins?

609


How bulk collect improves performance?

573