k_murli_krishna
asked on
No pseudo columns in DB2
1) Like we have rownum, rowid in oracle, we do not have pseudo columns in DB2.
2) What if we want first few, last few or a range of records in between. How
do we fetch them.
3) We can use a sequence as one column but that is not the way I would like it.
4) Please give example queries.
2) What if we want first few, last few or a range of records in between. How
do we fetch them.
3) We can use a sequence as one column but that is not the way I would like it.
4) Please give example queries.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
6) This we can query with range in where clause. Please give me sample example for this route.
7) More points assured for each good and valid answer.