Hi............. No. you cann't use this. this query will display r

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?

Question Posted / mr. cooooool

3 Answers
7532 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

Please Help Members By Posting Answers For Below Questions

Describe major components of db2?

1089

What is the maximum size of varchar data type in db2?

1130

what is utility for parm lib

2368

What is check constraint in db2?

1076

Are view updateable?

1039

What is precompiler in db2?

1009

How to find primary key of a table in db2?

1059

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1156

How is a typical db2 batch pgm executed?

1171

On which levels locks can be applied?

1122

What is image copy in db2?

1010

What is a db2 schema?

1222

What is the role of data manager in the db2 database?

1100

What is runstats and reorg in db2?

1295

What is cobol db2?

992