PokeVideoPlayer v23.9-app.js-020924_
0143ab93_videojs8_1563605_YT_2d24ba15 licensed under gpl3-or-later
ImmersiveAmbientModecolor: #c3c09a (color 2)
Video Format : (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: 140 ( High )
PokeEncryptID: 3de38c3c16ea155b240c1cd9324209da2a827b81fe7b606a85d4a7de8cc66e70b281abb3bc6e9a038f6573f3b7f9d534
Proxy : eu-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1732554643146 - unknown on Apple WebKit
Mystery text : YVRDYTUwUVVBNncgaSAgbG92ICB1IGV1LXByb3h5LnBva2V0dWJlLmZ1bg==
143 : true
5,935 Views • Jul 24, 2024 • Click to toggle off description
============
Watch how to configure Oracle on VS Code • How To Setup ORACLE DATABASE on VS CO...
============
The camera gear I use in my Videos
www.amazon.in/shop/manishsharma?listId=DU9UM0XL97K…
============
Connect With Me on My Social Media
www.instagram.com/RebellionRider/
www.facebook.com/TheRebellionRider/
twitter.com/RebellionRider
www.linkedin.com/in/mannbhardwaj/
============
FAQ
Which book to refer to learn -
PL/SQL amzn.to/2QE1jX0
Performance Tuning amzn.to/2sgiAw4
1z0-071 Exam amzn.to/2sgfeJw
Python Programming amzn.to/305UEbh
============
AFFILIATE DISCLOSURE:
Some of the links used in the description will direct you to Amazon.in. As an Amazon Associate, I earn from qualifying purchases at no additional cost to you.
#rebellionrider
=============
I’ve got an SQL trick that will level up your data engineering game! 💻🚀
As someone who earned the Oracle SQL Expert 1z0-071 certification and recently published 'Mastering SQL Window Functions,' I’m always on the lookout for efficient and innovative ways to handle data. Today, I’m sharing a quick SQL trick that can fetch unique records from your database without using the DISTINCT keyword.
Imagine you need to fetch all the unique records from a column in your table. The usual approach would be to use the DISTINCT keyword. But here’s the twist—how do you achieve this without using DISTINCT, subqueries, or CTEs? 🤔
It’s simpler than you think. Use the GROUP BY clause! This groups the results by the column you want, giving you unique records effortlessly.
Fun fact: A study by Gartner reveals that effective data management, including SQL optimization, can improve decision-making efficiency by up to 33%. 🌐📊
Try it out and let me know if you knew this trick already! Comment below and share your thoughts or any other cool SQL tips you have! Let’s keep learning toget
Views : 5,935
Genre: Education
License: Standard YouTube License
Uploaded At Jul 24, 2024 ^^
warning: returnyoutubedislikes may not be accurate, this is just an estiment ehe :3
Rating : 4.981 (2/413 LTDR)
99.52% of the users lieked the video!!
0.48% of the users dislieked the video!!
User score: 99.28- Masterpiece Video
RYD date created : 2024-11-15T12:05:21.944467Z
See in json
24 Comments
Top Comments of this video!! :3
I knew this.But when you said not using sub query distinct or cte, got confused a while.😅
4 |
Select first_name from employees
Union
Select first_name from employees;
1 |
Nice question
2 |
Great one.
|
I know before. Another techique is
SELECT a.first_name
FROM your_table_name a
LEFT JOIN your_table_name b
ON a.first_name = b.first_name AND a.rowid > b.rowid
WHERE b.first_name IS NULL;
1 |
Without aggregate functions group by doesn't work
2 |
Nice trick, I've used this. But effective
|
Which is a more efficient way to save costs?
|
So count(first_name)
1 |
To fetch last second record from table.
|
Hi can I ask u something ?Did sql server can fail to pass exam?
|
i knew this , but is it cost effective ?
|
I know this
|
@abhisheksinha1597
2 months ago
select emp.first_name from
(select e.first_name,row_number() over (partition by first_name) as row_num from employees e) emp where row_num=1
2 |