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
Handmade Character Soft Toys
anil1961
Updated:
Yesterday at 2:11 PM
Bodim.lk out now !
Manoj Suranga Bandara
Updated:
Sunday at 3:05 AM
Power Lifting Lever Belt
SkullVamp
Updated:
Jun 13, 2026
Ad icon
port.lk Domain for sale
Lankan-Tech
Updated:
Jun 13, 2026
Colombo
Kaduwela - Two Storey House for Sale
dilrasan
Updated:
Jun 11, 2026
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
Hath warak paha keeyada? (hatha wadikireema paha)
Post reply
Top
Bottom