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

If I have a view which is a join of two or more tables, can this view be updateable?

1082

What is a db2 tablespace?

998

What is dbrm in db2 database?

1032

List out the buffer pools in db2

1020

What is a bind in db2?

983

How does cobol compile db2 program?

1006

How to find schema of a table in db2?

951

On which levels locks can be applied?

1061

How can you find out the # of rows updated after an update statement?

1051

What are the various data types available in db2?

1012

What does sqlcabc has?

994

Is db2 a mainframe database?

943

What is commit in db2?

996

Why do we bind in db2?

1140

What is database manager in db2?

966