select * from emp where rownum<121 minus (select * from empwhere rownu

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / swapna

Answer Posted / swapna

select * from emp where rownum<121
minus (select * from empwhere rownum<100);

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is sql used for?

1164

How do you break a loop in pl sql?

1101

What can sql server reporting services do?

1163

differentiate between float and double. : Sql dba

1110

What is crud stand for?

1048

Can a key be both primary and foreign?

1054

How subquery works in sql?

1128

Is sql workbench free?

1044

What are the subsets of sql?

1195

What is the difference between microsoft access and sql?

1074

Can you rollback after commit?

1049

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1282

What is the use of count (*) in sql?

1117

Differentiate between sga and pga.

1206

Do we need to create index on primary key?

966