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
- 7406 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
Answer / anju
I dont think records are stored in the sorted order of primary key in DB2. It happens only in VSAM!
| Is This Answer Correct ? | 2 Yes | 1 No |
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is the syntax for FETCH in DB2 ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
Where do you specify them?
Which transaction use a command thread ?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the advantage in De-normalizing tables in DB2?
What does DML stand for and what are some examples of it?
What is the use of db2?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What is the role of schema in the db2 database?
What is the SQL Communications Area and what are some of its key fields?
COBOL 
