Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
12
Reply
problem at the time of fetching data in sql server
Ravi Shekhar
Aug 1 2013 6:37 AM
884
Reply
Now when i run this query
Select distinct slot_code,COUNT(MonoboxNo) capacit from wms_loose_transaction
Where Statustemp='PKL035311' and left(monoboxno,7)='1619199' and statustemp1='H' group by slot_code
I got SAFL21 20
but i need order wise like in above table i have two orders with same artno
not i need to fetch data order wise.
desired data SAFL21 10 for both orders.
Pls give me a query.(above image in attachment.you can download for reference)
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
12
)
Next Recommended Forum
Sql server
cursor in sql server