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
Devendra Kumar
NA
500
164.2k
SQL query for stock calculation
May 6 2018 3:25 PM
I am having a table named Purchase, that contains column like
Date, ItemCode, Rate, Qty
03-05-2018 001 10 5
13-05-2018 002 25 15
17-05-2018 001 45 50
25-05-2018 002 55 2
26-05-2018 001 10 25
Each ItemCode has different Rate. I want the output as how much qty is purchased of different amount having same Itemcode
Output like
ItemCode Rate Qty
001 10 30
001 45 50
002 25 15
002 55 2
Please help me with the query
Reply
Answers (
1
)
Difference between NOT IN and exists in sql server?
Stuff with XML PATH