Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
17
Reply
Need query for this Output
Ankit Shukla
Feb 28 2017 5:41 AM
305
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
17
)
Next Recommended Forum
Get Credit number
How to calculate datetime udf function problems