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 Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

Are views updateable?

0 Answers  

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

How does DB2 use multiple table indexes?

1 Answers  

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

What do you mean by commit and rollback?

0 Answers  

How could one combine a set of incremental image copies into a single copy?

1 Answers  

How will you delete duplicate records from a table?

7 Answers   Google,

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

What is ibm db2 used for?

0 Answers  

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers