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

give the syntax of grant and revoke commands? : Sql dba

1138

What is a sql select statement?

1023

How do you break a loop in pl sql?

1032

What does 0 mean in sql?

952

What are records give examples?

991

Explain the types of joins in sql?

1015

How many primary keys can a table have?

988

Does user triggers have entry for trigger with compilation errors?

1019

Why cross join is used?

1061

How to select all records from the table?

1118

How do I start pl sql?

933

how to increment dates by 1 in mysql? : Sql dba

960

Enlist the data types that can be used in pl/sql?

1050

How do you optimize a query?

977

what is try_catch block in procedure

1723