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
7555 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

How to get the ddl of a table in db2?

1134

What's The Error Code For Unique Index Voilation?

1244

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

1111

what is the sqlcode -501

13170

What are db2 objects?

1053

List out the three types of page locks that can be held.

1151

How to restart a DB2 program?

1911

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1276

What does a deadlock mean in DB2?

1170

Define db2 and its databases?

1060

How would you find out the total number of rows in a db2 table?

1057

Explain about rct.

1093

What does db2 stand for?

1033

What is dbrm?

1113

What is db2 command?

1044