if empno is a primary key then the records in table are stored in ascendi

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 / madhu t

3 Answers
7556 Views
I also Faced
E-Mail Answers

Answer Posted / madhu t

if empno is a primary key then the records in table are
stored in ascending order of empno. hence we can use empno
< 5 to fetch the first 4 records of table.
There is also a standar query to fetch the first 10/100/200
records as below...
select empno,sal from emptble fetch first 100 rows only;

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does runstats do in db2?

1126

What is the purpose of rollback and commit?

1200

Discuss about db2 bind?

1104

Explain about rct in db2?

1115

Explain package in db2 and its advantages?

1221

What is isolation level in db2?

1016

What are host variables in db2?

1076

How do I change the column size in db2?

1162

Define check constraint.

1084

What are concurrency issues?

1107

What is table space in db2?

1025

What is the difference between db2 and oracle?

1136

Explain about dbrm.

1052

What does reorg do in db2?

1038

What is db2 instance?

1110