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

Which is faster joins or subqueries?

554


What does the acronym acid stand for in database management?

546


What is rowtype?

568


Does oracle roll back the transaction on an error?

537


How do I find duplicates in two columns?

552






What happens when a trigger is associated to a view?

504


What is compiled query?

522


How do I view a table in sql?

545


What is the difference between the sql*loader and import utilities? : aql loader

600


How do I quit sql?

502


What is the use of index in hive?

548


Why should I use postgresql?

566


Which table is left in left join?

527


What is difference between ms sql and mysql?

476


What is a null value?

657