shms 0 Report post Posted June 2, 2008 Salam..aku ada wat select max utk data seperti di bawah ..-----------------------BoxNo----------------------11234510111213141516171819202156789 --------------------code dia gini SELECT MAX(BoxNo) AS Expr1 FROM viewDLabelSVC WHERE (CustInv = 'MB0323V')result dia dapat gini :---------Expr1---------9Datatype utk field ni adalah NVARCHAR Persoalannya : Napa dia select 9? sedangkan 21 adalah boxno yg paling max dalam list tu .. aku jadi kompius ..atau dia akan select row paling bawah?Tlg jawap persoalan aku ini wahai otai2 yg budiman. Sekian dulu Quote Share this post Link to post Share on other sites
cade 0 Report post Posted June 3, 2008 mngkin sbb ko bubuh where condition tu la kot Quote Share this post Link to post Share on other sites
shms 0 Report post Posted June 4, 2008 (edited) where condition tu utk filter ja. sbb aku nak cari boxno yang maximum dalam customer invoice = 'MB0323V' Edited June 4, 2008 by shms Quote Share this post Link to post Share on other sites
arejae 0 Report post Posted June 4, 2008 Salam, saya try jawab yer. Masalah nie adalah disebabkan datatype ialah nvarchar. kita kena convert dia jadi int.Solution:SELECT MAX(CAST(BoxNo AS INT)) AS Expr1 FROM viewDLabelSVC WHERE (CustInv = 'MB0323V')utk keterangan lanjut,boleh baca kat sini Quote Share this post Link to post Share on other sites
shms 0 Report post Posted June 4, 2008 betol2 ..aku da try..dan resultnya seperti yg aku nak. TQ so bleh close la topic ni..sbb da dpt penyelesaiannya .. TQ lagi skali Quote Share this post Link to post Share on other sites
arejae 0 Report post Posted June 4, 2008 ok.good. Quote Share this post Link to post Share on other sites