Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
I want to Sql Query to Present data from Database Table
Pnkl
Sep 24 2012 5:09 AM
1.6k
Reply
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
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Microsoft Certificate
Stored Procedure-Pivote Table