Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!
- 17 Answers
- 27765 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is the use of db2 optimizer?
What is the use of with ur in db2?
How can record locking be achieved in those DB2 versions which do not support it?
Which isolation level provides maximum concurrency?
Explain the contents that are a part of dclgen.
can all users have the privilage to use the sql statement select * (dml)?
What is buffer pool in the db2 database?
Mention the different locking levels that are available in db2.
What is db2 look?
When do you specify the isolation level?
When reorg is used?
What is rct?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is precompiler in db2?
What is null indicator in db2?
