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

how to retrive only second row from table?

Question Posted / sushma s

Answer Posted / sushma s

select * from emp where rownum<=2
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 to avoid duplicate records in a query?

1004

What is sql lookup?

915

What is clustered index in sql?

1050

what are the features and advantages of object-oriented programming? : Sql dba

1004

What are types of indexes in sql?

1076

what is the command line end user interface - mysql? : Sql dba

981

how to do backup entire database? : Transact sql

1141

Are null values same as that of zero or a blank space?

1023

What is a string data type in sql?

1033

what are set operators in sql? : Sql dba

1046

What is sql and how does it work?

1163

what is oracle database ? : Sql dba

1020

What is a temp table?

1023

What is the use of nvl function?

1193

how many columns can be used for creating index? : Sql dba

944