Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7492 Views
- I also Faced
- E-Mail Answers
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 does db2 stand for?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is a db2 tablespace?
What is the physical storage length of the data types date, time, and timestamp?
How to find the number of rows in a db2 table?
What are the rules for db2 programming?
How do you pull up a query which was previously saved in qmf?
What is the max length of sqlca?
Where can you declare a cursor in a cobol-db2 program?
What is runstats db2?
Can we update view in db2?
What is the purpose of using commit?
Explain how can you do the explain of a dynamic sql statement?
Name the various locking levels available?
What is database alias db2?
