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
Ankit Shukla
NA
681
117.6k
Need query for this Output
Feb 28 2017 5:41 AM
Hello,
I have a table named "Shipment":
carton_no
itemno
location_code
quantity
AD/00005/ER
FLOWER2
BLOCK 4
6
AD/00007/ER
FLOWER2
BLOCK 4
1
AD/00003/ER
FLOWER
BLOCK 4
4
AD/00004/ER
FLOWER
BLOCK 4
4
AD/00005/ER
FLOWER
BLOCK 4
4
AD/00003/ER
FLOWER2
BLOCK 4
6
AD/00003/ER
FLOWER
BLOCK2
3
AD/00005/ER
FLOWER
BLOCK 4
4
I need output:
carton_no
itemno
location_code
quantity
AD/00003/ER
FLOWER
BLOCK 4
7
AD/00003/ER
FLOWER2
BLOCK 4
6
AD/00004/ER
FLOWER
BLOCK 4
4
AD/00005/ER
FLOWER
BLOCK 4 8
AD/00005/ER
FLOWER2 BLOCK 4
6
AD/00007/ER
FLOWER2
BLOCK 4
1
Thanks in Advance
Reply
Answers (
17
)
Get Credit number
How to calculate datetime udf function problems