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

What is delimiter in pl sql?

739

How long will it take to learn pl sql?

689

Does truncate need commit?

697

Why partition by is used in sql?

726

What is a unique constraint?

807

what is meant by urlencode and urldocode? : Sql dba

768

Why we use joins in sql?

723

how to get a list of all tables in a database? : Sql dba

690

Enlist the advantages of sql.

742

What is sql indexing?

752

what is the difference between a web-garden and a web-farm? : Sql dba

752

What type of database is cloud sql?

778

Is sql pronounced sequel or sql?

951

what are the limitations of identity column? : Transact sql

822

Mention what does plv msg allows you to do?

853