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 | |
DRISHTYPosted Sep 24, 2012, 6:43 AM
(SELECT * FROM (SELECT TOP 3 * FROM TABLE1 t2 WHERE t2.ITEM = t1.ITEM ORDER
BY PRICE desc) x WHERE x.ID = t1.ID) order by ITEM desc, PRICE desc
selvi subramanianPosted Sep 25, 2012, 7:05 AM
PnklPosted Sep 24, 2012, 7:34 AM
Your Query is a perfect .....