Shall i use this query to retrieve first 4 records,
Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?
Answer Posted / mr. cooooool
Hi.............
No. you cann't use this.
this query will display records less than 5.
not to for first 4 records.
For exm.
Suppose i have duplicate records like
Empno
1
2
1
1
3
4
then it display all the above records.
b'coz these all r less than 5.
Thanks.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is buffer pool in the db2 database?
What is phantom read in db2?
What is bind and rebind in db2?
What is deadlock in db2?
Define db2 and its databases?
Describe major components of db2?
Define declaration generator (dclgen).
What is the use of db2 optimizer?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is schema in db2?
What is buffer pool and list some of them?
What are the contents of a dclmgen?
Is it possible using max on a char column?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What kind of database is db2?