TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Pnkl
NA
114
66k
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 :
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
Reply
Answers (
3
)
Microsoft Certificate
Stored Procedure-Pivote Table