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 sql catalog?

1014

What is the difference between the conventional and direct path loads? : aql loader

1394

What is normalisation and its types?

1000

When should I use nosql database?

1006

What are the two parts of design view?

1018

what are all different types of collation sensitivity? : Sql dba

980

define join and explain different type of joins? : Sql dba

950

What is clustered and nonclustered index in sql?

939

How do you define a foreign key?

995

Does sql use python?

1024

Is sql a microsoft product?

946

how to get a list of columns in an existing table? : Sql dba

964

What is a .db file?

984

How many types of normalization are there?

957

List the various privileges that a user can grant to another user?

1038