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="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
Hath warak paha keeyada? (hatha wadikireema paha)
Post reply
Top
Bottom