string cmd = "select Itemname,item_variant,size,quantity from tbl_precount";
Itemname item_variant size quantity Manhattan black XS 60 black XS 70 black XS 90
ROPONGGIA black XS 60 black XS 11 black XS 100
select top 1 itemname,item_variant,size,quantity from tbl_precount order by itemname, per size, and per item_variant desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)