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 |
|
|
|