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 difference between inner join and cross join?

969

difference between anonymous blocks and sub-programs.

1134

What is trigger in pl sql with examples?

1041

What plvcmt and plvrb does in pl/sql?

1323

How do I create a memory optimized filegroup?

959

Can I learn sql in a week?

1073

How many rows can sqlite handle?

1112

How to use sql*plus built-in timers?

1200

what are the different type of sql's statements ? : Sql dba

926

What do you know by pl/sql cursors?

1105

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

Which software is used for pl sql programming?

986

how to load data files into tables with 'mysqlimport'? : Sql dba

1092

Does oracle use sql?

927

Does truncate release storage space?

1077