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

What are db2 objects?

1091

What is phantom read in db2?

1224

Is db2 a programming language?

1101

What is difference between alias and synonym in db2?

1197

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1538

What's The Error Code For Unique Index Voilation?

1306

What is a db2 cursor?

1108

What is the cobol picture clause of the db2 data types date, time, timestamp?

1123

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1134

What are iseries servers?

1132

What is check constraint. Explain with example.

1163

What is temporal table in db2?

1101

How to fetch the last row from the table in SQL (db2)?

1696

Highlight all the advantages that are attached to a package.

1169

Mention data types used in db2 ?

1201