wanna help abt SQL...(urgent)

ad.hasareli

Well-known member
  • Mar 27, 2010
    5,264
    580
    113
    දකුනේ කොල්ලෙක්
    ane mata sql aka gahala dennako netnam bump akak wath dala yanna ada poya dawase attatama loku pinak :yes::yes::yes::yes:


    itm.jpg



    Machanla mekeai wenna oni...........

    Hema itemcode akakama max(last) loadingnumber aken thiyena item tika display kara ganna oni.......
     

    ad.hasareli

    Well-known member
  • Mar 27, 2010
    5,264
    580
    113
    දකුනේ කොල්ලෙක්
    SELECT DISTINCT itemname,itemcode, max(loadingNumber)
    from loading

    try this .




    same machan..... recodes group by itemname dipu gamam recodes duplicate wenawa ban.....
    mata theruna vidihata ubata one mekada.ubata ona eka poddak explain karapan.


    select itemname,itemcode, max(loading)
    from loading
    group by itemcode


    ow machan oka tamai wenna ona.....
    mata mekan itemname akath dispaly kara ganna oni

    select itemcode, max(loadingNumber)
    from loading
    group by itemcode



    select itemname,itemcode, max(loadingNumber)
    from loading
    group by itemcode,itemname

    mehema dipu gaman recodes duplicate wenawa ban.... akat karanna deyak kiyapanko.....
     

    sanjayy

    Member
    Jul 16, 2012
    5
    2
    0
    Try this...

    select DISTINCT itemcode,max(loadingNumber)
    from yourtable
    group by itemcode

    Edited [sorry, i didnt see that someone already posted a similar one]
     
    Last edited:
    • Like
    Reactions: ad.hasareli

    NO_MeRcY

    Well-known member
  • Jun 14, 2010
    5,423
    449
    83
    Singapore
    me SQL aka hari machan.... mata itemname akath display karaganna oni machan..

    select itemname,itemcode, max(loadingNumber)
    from loading
    group by itemcode,itemcode

    ithin mama me widihata sql aka liya gatta bt data duplicate wenawane :(.... plz machan help meeeeeee :(:(:(


    Code:
    select itemcode,max(loadingNumber)
    from TEST
    group by itemcode
    
    
    select itemcode,max(loadingNumber),itemname
    from TEST
    group by itemcode,itemname


    uba kiyanne 2nd query eken ena data repeat wenawa kiyalada? eka wenna baha. 2nd query eke mul ekata wada wenas wenne itemname column eka add wena ekay itemname eken group by wena ekay.

    poddak dekama run karala balala kiyapan machang deken return wena rows gana wenas da kiyala . dekenma 4 rows neda return wenne.
     
    • Like
    Reactions: ad.hasareli