|
View previous topic :: View next topic
|
| Author |
Message |
tomrsan
New User
Joined: 15 Oct 2005
Posts: 13
Location: chennai
|
|
|
|
hi pls help me to
1.QUERY for retrieving first 15th record to 25th record?
2.QUERY for retrieving last record to 15th record? order of retrieval should be
last record
last but one record
......
........
.........
15th record |
|
| Back to top |
|
 |
khamarutheen
Active Member
Joined: 23 Aug 2005
Posts: 677
Location: NJ
|
|
|
|
hi frnd,
| Quote: |
| 2.QUERY for retrieving last record to 15th record? |
| Code: |
SELECT * FROM EMP
ORDER BY ENO DESC
FETCH FIRST 15 ROWS ONLY
|
i have not tried the above query but plz check it...
else u can go for between with any primary key
ie.,
| Code: |
SELECT * FROM EMP WHERE EMPNO BETWEEN 15 AND 30
ORDER BY EMPNO DESC |
| Quote: |
| 1.QUERY for retrieving first 15th record to 25th record? |
| Code: |
| SELECT * FROM EMP WHERE EMPNO BETWEEN 15 AND 25 |
hope got it |
|
| Back to top |
|
|
tomrsan
New User
Joined: 15 Oct 2005
Posts: 13
Location: chennai
|
|
|
|
hi
thanx 4 aswering now iam cleared |
|
| Back to top |
|
|
|
|
