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
- 7498 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
What is the meaning concurrency in the db2 database?
What are the benefits of using the db2 database?
What is package in db2 mainframe?
Explain about dbrm.
How to fetch the last row from the table in SQL (db2)?
Define data page.
Which isolation level provides maximum concurrency?
Which component is responsible for processing sql statements and selecting access paths?
What is difference between alias and synonym in db2?
Which component is used to execute the sql statements?
What does sqlcabc has?
What is cursor with hold option in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do you select a row using indexes in db2?
What is a trigger in the db2 database?
