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 a record in a database ? : Sql dba

572

How do I view a view in sql?

512

How do you sort in sql?

612

How do I run a pl sql program?

637

Is postgresql a nosql database?

544

What is relationship? How many types of relationship are there?

599

What is dcl in sql?

532

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

575

What do you understand by exception handling in pl/sql?

584

Why do we need cursor in pl sql?

658

Do ddl statements need commit?

546

What is sql scripting?

571

what are the types of subquery? : Sql dba

597

What is pragma in sql?

628

What is the starting oracle error number? What is meant by forward declaration in functions?

551