how to retrive only second row from table?

Answer Posted / sandhya rani

This is perfect answer...
and do not misguide the ppl by simply writing wrong answer.
until and unless u r perfect..pls do not share your answer


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

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of cursors are available in pl/sql?

674


How do I run pl sql in sql developer?

747


How can I speed up sql query?

624


When is the explicit cursor used ?

672


What is java sql package?

626






Show how functions and procedures are called in a pl/sql block.

679


How do you write an inner join query?

603


What is the best free sql database?

655


When do we use triggers?

683


What can I use instead of union in sql?

596


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

636


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

858


how to drop an existing index in mysql? : Sql dba

623


What is oracle pl sql developer?

616


What are the types of index in sql?

638