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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / bsanjib

21 Answers
26885 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / laks

select * from emp where rownum<121
minus(select * from emp where rownum<101)

Is This Answer Correct ?

34 Yes

4 No

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

Answer / swapna

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

Is This Answer Correct ?

11 Yes

6 No

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

Answer / d

select *
from (select rownum row_num
,tab.*
from table tab)
where row_num between 100 and 120

Is This Answer Correct ?

7 Yes

2 No

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

Answer / subhradeep

select * from employees where rownum<102
minus(select * from employees where rownum<81)

Is This Answer Correct ?

2 Yes

0 No

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

Answer / gourav josih

select *from employees
where employee_id between 120 and 150;

Is This Answer Correct ?

4 Yes

2 No

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

Answer / nayana

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / arif hussain

select * from (
select ROW_NUMBER() over (order by tablename.columnname)as ronno,* from tablename )x
where ronno between 100 and 120

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mohan

select * from table_name where rownum between 100 and 120;

Is This Answer Correct ?

2 Yes

2 No

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

Answer / anjana

Select *,row_number over(partition by departmentid order by empid)as rowid from employeeDept
where rowid between 100 and 120

Is This Answer Correct ?

1 Yes

1 No

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

Answer / srinivas

select * from(select <table_name>.*,rownum rn from <Table_name>) where rn between 100 and 120

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers

write a query to delete similar records in particular fields(columns) in different tables

6 Answers TCS,

How to display the contents of a current record fetched in a reference cursor?

2 Answers

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers Maruti Suzuki,

Can we use ddl commands in pl sql?

0 Answers

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers Sonata,

Where is sql database stored?

0 Answers

List out the acid properties and explain?

0 Answers

What does joining a thread mean?

0 Answers

What is thread join () in threading?

0 Answers

What is bulk collections?

2 Answers

For more SQL PLSQL Interview Questions Click Here