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

Does view contain data?

606


Why we use cross join?

532


what is the command used to fetch first 5 characters of the string? : Sql dba

1124


What is nvl?

603


What is clustered index in sql?

576






What is a relationship and what are they?

568


What is partition by in sql?

558


What is the difference among union, minus and intersect?

536


What is data modelling in sql?

511


What are the two types of exceptions in pl/sql?

529


How to set up sql*plus output format in oracle?

584


what are the differences between require and include, include_once and require_once? : Sql dba

516


How sql query is executed?

542


What is the difference between inner join and natural join?

499


explain the difference between myisam static and myisam dynamic. : Sql dba

505