Answer / prasenjit

With reference to Mr.Om......
In the question itself i had mentioned that you are not
supposed to use any keys....so that negates your query
where u have used empno as a key!

Arent there any solution for this?

Answer / saeed

db2 "SELECT EmpNo FROM (SELECT EmpNo, dense_rank() over
(order by EmpNo) RNo FROM office) xyz WHERE RNo >= 100 AND
RNo<=200 "

Answer / vijay reddy

select * from (select * from emp ) where rownum>=1 and rownum<5

Answer / om yadav

mr. Prasenjit ..
when you are going to select 100 record then you select
which column base you want the record taht base you mession
on condition.
than
if any other way please tell me.........

Answer / om prakash yadav

select * from <Table name> where <condition>

condition:- using BETWEEN

eq:-

select * from emp where empno between( 100 to 200).

Answer / om prakash yadav

Note= Before i given the query it is worng pleas ignopre it.
Thanks.
========================================

using cursors you can do>


CURSOR Crs_trs IS
SELECT empno, empname, sal, deptno from emp WHERE empno
between 100 and 200;

vr_empno.empno%type;
vr_empname.empname%type;
vr_sal.sal%type;
vr_deptno.deptno%type;

BEGIN
OPEN Crs_trs;
IF crs_trs%ISOPEN THEN
LOOP
FETCH Crs_trs INTO vr_empno, vr_empname, vr_sal, vr_deptno;

dbms_output.put_line('empno__'||vr_empno );
dbms_output.put_line('empname__'||vr_empname);
dbms_output.put_line('empsalary__'||vr_empsal );
dbms_output.put_line('empdeptno__'|| vr_deptno);

EXIT WHEN Crs_trs%NOTFOUND;
END IF;
END LOOP;
CLOSE Crs_trs;
END;

Answer / kumar

try this one.....


select * from emp where count(*) > 100 and count (*) < 200;

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

What are leaf pages?

3 Answers  

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

What is the difference between spufi and qmf?

0 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

How is a typical DB2 batch program executed ?

1 Answers  

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,