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
Ad icon
Gampaha
Thenya Mishel
menuka2000
Updated:
Wednesday at 10:48 PM
Handmade Character Soft Toy Bluey Bingo
anil1961
Updated:
Aug 3, 2026
Colombo
Dahua POE Switch 8 Ports (DH-PFS3010-8ET-65)
hashaz2012
Updated:
Aug 3, 2026
Ad icon
Singapore V2Ray VPN for Tunneling
hu KANNA
Updated:
Jul 31, 2026
Dating Website & Online Chat Room
hotvideo
Updated:
Jul 30, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
MYsql උදව්වක් ඕනි වෙලා තිබේ . Help!!!
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="TNHM" data-source="post: 24698951" data-attributes="member: 561032"><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'">select a.id, a.date, </span></span></span></p><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'">(select max(time) from att a2 where a2.id = a.id and a2.status = 'Checkin' and a2.date = a.date) as check_in,</span></span></span></p><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'">(select max(time) from att a3 where a3.id = a.id and a3.status = 'Checkout' and a3.date = a.date ) as check_out,</span></span></span></p><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'">from att a whete data between 2019-01-05 and 2019-03-05</span></span></span></p><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'"></span></span></span></p><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'"></span></span></span></p><p><span style="font-size: 15px"><span style="font-family: 'Courier New'"><span style="font-family: 'Comic Sans MS'">ඔන්න ඔහොම එකක් ලියන්න පුළුවන්. ඕක සුදෝ කෝඩ් එකක්. ඔය පැටර්න් එකට ලියන්න පුළුවන් වෙයි. මම නිකන් ලිව්වේ රන් කරලා බැලුවේ නැ. නැත්නම් application level එකේදී report එක හදන්න.</span></span></span></p></blockquote><p></p>
[QUOTE="TNHM, post: 24698951, member: 561032"] [SIZE="4"][FONT="Courier New"][FONT="Comic Sans MS"]select a.id, a.date, (select max(time) from att a2 where a2.id = a.id and a2.status = 'Checkin' and a2.date = a.date) as check_in, (select max(time) from att a3 where a3.id = a.id and a3.status = 'Checkout' and a3.date = a.date ) as check_out, from att a whete data between 2019-01-05 and 2019-03-05 ඔන්න ඔහොම එකක් ලියන්න පුළුවන්. ඕක සුදෝ කෝඩ් එකක්. ඔය පැටර්න් එකට ලියන්න පුළුවන් වෙයි. මම නිකන් ලිව්වේ රන් කරලා බැලුවේ නැ. නැත්නම් application level එකේදී report එක හදන්න.[/FONT][/FONT][/SIZE] [/QUOTE]
Insert quotes…
Verification
Haya warak paha keeyada? (haya wadi kireema paha)
Post reply
Top
Bottom