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
27689 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 / ajit

select Ename, empno, rn
from (select rownum rn, ename, empno
from emp)
where rn between &gno and &gno

Is This Answer Correct ?

0 Yes

0 No

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

Answer / ajit nayak

select rn, ename
from (select rownum rn, ename
from emp)
where rn between 3 and 7;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sagar sananse

with admitCTE(AdmissionId,PatientId,RN) as
(
select AdmissionId,PatientId,Row_number() over (order by AdmissionId) as RN from tempadmit
)
select * from admitCTE where RN between 101 and 120

Is This Answer Correct ?

0 Yes

0 No

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

Answer / jayanth

select * from (select a.*, row_number() over (order by empno) rn from emp a) where rn between 100 and 120;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / nancy

select * from (
select tn.*, rownum rd from emp tn ) where rd between 100 and 200;

or

select * From (select tn.* from emp tn where rownum <201
minus
select tn.* from emp tn where rownum <100)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / manjunath

select level from dual connect by level<=150
minus select from dual connect by level<=120;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sravan

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

Is This Answer Correct ?

13 Yes

14 No

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

Answer / bhargav

SELECT * FROM
(
SELECT Row_Number() OVER (ORDER BY emp_id, emp_name) as
emp_name
FROM employees
) as a
where rowid >100 AND rowid<121

Is This Answer Correct ?

0 Yes

1 No

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

Answer / gourav

SELECT * FROM EMPLOYEES
WHERE EMPLOYEE_ID BETWEEN 120 AND 150;

Is This Answer Correct ?

2 Yes

5 No

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

Answer / sum

select * from employees where rownum between 100 and 120

Is This Answer Correct ?

2 Yes

15 No

Post New Answer

More SQL PLSQL Interview Questions

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

2 Answers

What version is sql?

0 Answers

How to place comments in pl/sql?

0 Answers

How many tables can you join in sql?

0 Answers

What is left inner join in sql?

0 Answers

What is the plv (pl/vision) package offers?

0 Answers

What is rownum?

0 Answers

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers

Is sql dba a good career? : SQL DBA

0 Answers

what is variable in package specification

3 Answers

When the mutating error will comes? and how it will be resolved?

2 Answers

How to look at the current sql*plus system settings?

0 Answers

For more SQL PLSQL Interview Questions Click Here