how to retrive only second row from table?

Answer Posted / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<2);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pronounce postgresql?

769


What is Collation Sensitivity ? What are the various type ?

698


Name the different types of indexes in sql and define them.

782


What is a natural join sql?

706


explain about mysql and its features. : Sql dba

743






Describe different types of general function used in sql?

728


Is crud a cuss word?

778


Can we perform dml in function?

796


What are instead of triggers?

791


What will you get by the cursor attribute sql%notfound?

779


Why left join is used in sql?

705


What is prepared statement in sql?

750


Explain sql data types?

830


How many joins in sql?

738


What are the benefits of pl/sql packages?

740