(select * from emp where rownum<3) minus (select * from emp where rownu

how to retrive only second row from table?

Question Posted / rajeev thakur

Answer Posted / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<2);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how mysql optimizes distinct? : Sql dba

1001

what is the syntax used for partition in tsql? : Transact sql

960

How do I audit the sql sent to the server?

958

What is auto increment?

936

What is dcl in sql?

907

What is informix sql?

924

Are stored procedures faster than queries?

901

How many sql commands are there?

1073

What do you mean by “trigger” in sql?

1019

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

978

Which kind of parameters cannot have a default value in pl sql?

1074

How many scalar data types are supported in pl/sql?

978

What is a sql instance vs database?

1038

Which data type is a composite type?

934

what are null values? : Sql dba

902