Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Toyota Vitz scp10 For Sale
Lakmal Bandara
Updated:
Today at 10:50 AM
Ad icon
Cam ෂෝ කරන්න ආස කෙල්ලෝ
vip video seller srilanka
Updated:
Today at 2:17 AM
Cam show job
vip video seller srilanka
Updated:
Today at 2:01 AM
Vip විඩීයෝ තියේ හොරෙන් රෙකෝඩ් කරපුවා
vip video seller srilanka
Updated:
Today at 1:26 AM
Kandy
Welcome all my all new pet shop Bark.lk
dilumrane
Updated:
Monday at 12:26 PM
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Help
wanna help abt SQL...(urgent)
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="tsomeone" data-source="post: 13143163" data-attributes="member: 410965"><p>select itemcode,max(loadingNumber) from TEST group by itemcode MEEKA MEHEMA DANNA</p><p></p><p>select itemcode,itemname from TEST group by itemcode,itemnameOY<span style="font-size: 18px">Oya widyata quary deka hadaganin machan, machan quary deka hari awula thiyenne data wala eekai data repeat ekak wenne man print screen eken dakke </span></p><p><span style="font-size: 18px">balahan same item name thiyna itemcode dekak tiyenawane ey ban ehema une eekai repeat ekak wenne so basically oyat tiynne data quary deka wenama save karala relationship ekak dala left outer join hari right outer join ekakin 3rd quary eka goda danna etakot repeat weemak nomatha eet ube data wala case tiyenawa balapan hariyat data dala</span></p><p><span style="font-size: 18px"></span></p><p><span style="font-size: 18px">Itemname eka thamai case eka ekama itemcode ekat ey wena wena itemname enne?</span></p><p><span style="font-size: 18px">ehema nowiya yuthui data hariyat enter karapan kollo nettan kochchara wada karat wadak ne</span></p><p><span style="font-size: 18px"></span></p><p><span style="font-size: 18px">ex: applepuff100 has 1001 & 1002</span></p><p><span style="font-size: 18px"></span></p></blockquote><p></p>
[QUOTE="tsomeone, post: 13143163, member: 410965"] select itemcode,max(loadingNumber) from TEST group by itemcode MEEKA MEHEMA DANNA select itemcode,itemname from TEST group by itemcode,itemnameOY[SIZE=5]Oya widyata quary deka hadaganin machan, machan quary deka hari awula thiyenne data wala eekai data repeat ekak wenne man print screen eken dakke balahan same item name thiyna itemcode dekak tiyenawane ey ban ehema une eekai repeat ekak wenne so basically oyat tiynne data quary deka wenama save karala relationship ekak dala left outer join hari right outer join ekakin 3rd quary eka goda danna etakot repeat weemak nomatha eet ube data wala case tiyenawa balapan hariyat data dala Itemname eka thamai case eka ekama itemcode ekat ey wena wena itemname enne? ehema nowiya yuthui data hariyat enter karapan kollo nettan kochchara wada karat wadak ne ex: applepuff100 has 1001 & 1002 [/SIZE] [/QUOTE]
Insert quotes…
Verification
Dawasata paya keeyak thibeda?
Post reply
Top
Bottom