Pnkl

Pnkl

  • NA
  • 114
  • 65.7k

I want to Sql Query to Present data from Database Table

Sep 24 2012 5:09 AM
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 :
 
IDItemPrice
17
Nuts - 20 mm
25
16
BEARING - 10 mm
24
15
BOLT - 12 mm
23
14
Nuts - 20 mm
22
13
BEARING - 10 mm
21
12
BOLT - 12 mm
20
11
Nuts - 20 mm
19
10
BEARING - 10 mm
18
9
BOLT - 12 mm
17
8
Nuts - 20 mm
16
7
BEARING - 10 mm
15
6
BOLT - 12 mm
14
5
Nuts - 20 mm
13
2
BEARING - 10 mm
12
1
BOLT - 12 mm
11



Result Table

17
Nuts - 20 mm
25
14
Nuts - 20 mm
22
11
Nuts - 20 mm
19
16
BEARING - 10 mm
24
13
BEARING - 10 mm
21
10
BEARING - 10 mm
18
15
BOLT - 12 mm
23
12
BOLT - 12 mm
20
9
BOLT - 12 mm
17





Answers (3)