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;

is it compulsory commitment control in journal?

0 Answers   TCS,

how can we find nth max salary from A table

5 Answers   IBM,

How and when does the db2 enforces the unique key?

0 Answers  

Compare a subselect to a join?

1 Answers  

What does DSNDB07 database do?

2 Answers  

what is parm utility

2 Answers   IBM,

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

what is db2 restart?

0 Answers  

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

What is the maximum length of sqlca?

0 Answers  

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

How to see the structure of db2 table??

4 Answers   IBM,