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:
Today 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="NO_MeRcY" data-source="post: 13142947" data-attributes="member: 289641"><p>[CODE]</p><p></p><p>select itemcode,max(loadingNumber)</p><p>from TEST</p><p>group by itemcode</p><p></p><p></p><p>select itemcode,max(loadingNumber),itemname</p><p>from TEST</p><p>group by itemcode,itemname</p><p></p><p></p><p>[/CODE]</p><p></p><p></p><p>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.</p><p></p><p>poddak dekama run karala balala kiyapan machang deken return wena rows gana wenas da kiyala . dekenma 4 rows neda return wenne.</p></blockquote><p></p>
[QUOTE="NO_MeRcY, post: 13142947, member: 289641"] [CODE] select itemcode,max(loadingNumber) from TEST group by itemcode select itemcode,max(loadingNumber),itemname from TEST group by itemcode,itemname [/CODE] 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. [/QUOTE]
Insert quotes…
Verification
Dahaya deken beduwama keeyada?
Post reply
Top
Bottom