12
Reply

problem at the time of fetching data in sql server

Ravi Shekhar

Ravi Shekhar

Aug 1 2013 6:37 AM
884


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)


Answers (12)
Next Recommended Forum