Ravi Shekhar

Ravi Shekhar

  • 361
  • 4.5k
  • 2.1m

problem at the time of fetching data in sql server

Aug 1 2013 6:37 AM


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)