Latest ads

🚀 එක පැකේජ් එකයි - මාසෙටම Unlimited Internet! 🌐
- sayuru bandara
- Updated: Yesterday at 10:57 AM
🎬 CapCut Pro 1 Month Access! LKR 600
- sayuru bandara
- Updated: Yesterday at 10:55 AM
🚀 Google One AI PRO Plan (Gemini Pro Activation) – 18 Months Access! LKR 2200
- sayuru bandara
- Updated: Yesterday at 10:53 AM
Canva Pro Lifetime Own Mail Activation LKR 500
- sayuru bandara
- Updated: Yesterday at 10:51 AM
Tele marketing executive
- nuwandse
- Updated: Monday at 12:27 PM

Reply to thread

Message: <blockquote data-quote="shenic" data-source="post: 17769715" data-attributes="member: 470894"><p><span style="color: DarkOrchid"><span style="font-size: 10px"><span style="color: Red">{03}</span></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">[1.] මෘදුකාංගයක් මගින් හැසිරවිය හැකි එකිනෙක සම්බන්ධයක් සහිත දත්ත සමුහයක්.</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">[2.] ඉහත සඳහන් දත්ත ගොනුව හැසිරවිය හැකි, පාලනය කල හැකි මෘදුකාංගයක්.</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">[3.]</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">a) Students -> SID , Books -> BookID</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">b) SID</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">c) එකම දත්ත තීරුවක ඇති සියලුම දත්ත, විවිධ අය ඇතුලත් කිරීමේදී ඇති වෙන වෙනස් කම් මගහැර, කළමනාකරණයේ පහසුව තකා එකම රටාවකට පෙළගැස්වීමට යොදන වාරණයක්. (උදා: දුරකථන අංකය: +94 -- -------)</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">d)</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">i) SELECT * FROM `Students`</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">ii) SELECT COUNT(SID) AS 'No_Stud' FROM `Students`</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">iii) SELECT a.SID, a.FName, a.LName, b.BookName FROM Students a JOIN Books b ON a.SID = b.SID</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">iv) SELECT a.FName FROM Students a JOIN Books b ON a.SID = b.SID WHERE b.Amount > 2000</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px">V) SELECT a.FName FROM Students a JOIN Books b ON a.SID = b.SID WHERE b.BookName LIKE 'D%' OR b.BookName LIKE 'd%'</span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"></span></span></p><p><span style="color: DarkOrchid"><span style="font-size: 10px"><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":-)" title="Smile    :-)" loading="lazy" data-shortname=":-)" />dull<img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /></span></span></p></blockquote><p></p>

Verification: Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Top Bottom