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

how to retrive only second row from table?

Question Posted / naresh raju

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

Please Help Members By Posting Answers For Below Questions

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

587

What do you understand by case manipulation functions?

537

What is trigger and types?

548

How to disable a trigger name update_salary?

658

What is foreign key sql?

541

What is the difference between joins?

523

How does postgresql compare to "nosql"?

563

What is an alias command?

559

What is data types in sql?

525

What does trigger mean in slang?

511

What are the two virtual tables available at the time of database trigger execution?

620

what is a composite key ? : Sql dba

582

How can you load microsoft excel data into oracle? : aql loader

604

What is a sql schema used for?

533

How do I remove all records from a table?

555