Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7374 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
How can we retrieve the total number of records in RPG & CLLE?
What is a db2 collection?
What is dbrm in db2 database?
Which component is used to execute the sql statements?
What is a db2 schema?
How do you find the maximum value in a column in db2?
What do you mean by between and in? Is between inclusive of specified range values?
How do I change the column size in db2?
What is runstats db2?
What is coalesce in db2?
Before you give the explain statement, what are the prerogatives?
What is netezza database?
What is multi row fetch in db2?
What is cursor with hold option in db2?
How to fetch the last row from the table in SQL (db2)?
