Dear Guys,
I Have one Table in this Many nos. of record but I want only last three record of each Item.
So, u have any Solution then reply me
see.. below
Thanks...
Table : | ID | Item | Price |
| 17 | | 25 |
| 16 | | 24 |
| 15 | | 23 |
| 14 | | 22 |
| 13 | | 21 |
| 12 | | 20 |
| 11 | | 19 |
| 10 | | 18 |
| 9 | | 17 |
| 8 | | 16 |
| 7 | | 15 |
| 6 | | 14 |
| 5 | | 13 |
| 2 | | 12 |
| 1 | | 11 |
|
|
|
Result Table
| 17 | | 25 |
| 14 | | 22 |
| 11 | | 19 |
| 16 | | 24 |
| 13 | | 21 |
| 10 | | 18 |
| 15 | | 23 |
| 12 | | 20 |
| 9 | | 17 |
|
|
|