SQL session 6 | Distinct, Order By, Limit, Like Keyword

SQL session 6 | Distinct, Order By, Limit, Like Keyword | Trendytech

Рет қаралды 61,091

Күн бұрын

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/?src=youtube&su...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
In this session we have talked about following things
TABLE OF CONTENT
1:24 Distinct
5:24 Order
13:25 Limit
23:45 Like
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Sumit LinkedIn - / bigdatabysumit
🔅Sumit Instagram - / bigdatabysumit
#SQL #RDBMS #database #bigdata #dataengineering

Пікірлер: 53

@sumitmittal07 Жыл бұрын

Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql7

@santoshsable1 2 жыл бұрын

The sessions have been really good till now. I really appreciate the efforts that you put in to provide your knowledge to us. A small request from my end that would really help us, is if you could provide the data as an attachment. So it will be really handy and good to practice with the same set of data that you teach. Thank-you. ..!!

@thakurmanu7102 2 ай бұрын

Thank you so much for sharing your knowledge with us. Amazing teaching skills.

@peternguyen3452 Жыл бұрын

Hi Sumit, really great lessons, but I agree with a lot of other commentors about how sharing the notepad seed data would be very helpful.

@_insanebuddy Жыл бұрын

Thanks sumit sir ! This series is amazing .

@rokibhasan5184 5 ай бұрын

3rd day of Learning SQL. Specially the multi level limit clause, that's something I found very new. As I have already did some courses from YT.

@itsme1674 2 жыл бұрын

Amazing lecture

@poojag4335 2 ай бұрын

Loved it

@santanuroy2121 Жыл бұрын

Hello Sumit Sir, I have installed in my Laptop MYSQL 8.0 and using SQL Yog IDE and I run "SELECT DISTINCT source_of_joining FROM students ORDER BY enrollment_date DESC LIMIT 5;" --- its work perfectly. No error showing in the result section Also I used same table DDL & DML....as you write in your note pad.

@drspark123 2 жыл бұрын

Thank you sir ..

@sukantabala2514 5 ай бұрын

Very good turorial.

@yashdhas8202 2 жыл бұрын

order by using column serial no was very new for me and amazing too. Excited for for session on joins.

@sumitmittal07 2 жыл бұрын

I hope you will find the upcoming sessions even more interesting :)

@ningus8522 Жыл бұрын

thanku sir..

@hrishipal3567 11 ай бұрын

Crazy good❤

@vinaykumar-oc7ev 6 ай бұрын

Which recording sw are you using?

@karthikeyankarthik4752 8 ай бұрын

like '_____' thanks for this scenario.Since i having exp of 9 year and i don't about this. Thanks sir.

@AGRIMTYAGI14 2 жыл бұрын

Can you please upload the notepad on google drive to refer the queries?

@somethingmeaningful 2 жыл бұрын

Please provide the notes you use during the session. Also let me from where can I download them.

@aparoopsaha8477 2 жыл бұрын

Sir, please include Cte and window functions soon.. I have to understnd thm very well. And getting understood by you is best sir. Crystal clear❤

@sumitmittal07 2 жыл бұрын

Definitely, as soon as possible

@shashankarya9481 2 жыл бұрын

where can i find this notepad file?

@dilawarjalil8842 Жыл бұрын

Thanks Sir

@gauravrajauria9460 2 жыл бұрын

Sir, the sessions are amazing and well explained. Thanks for this amazing stuff. Will you be covering the Normalisation?

@sumitmittal07 2 жыл бұрын

Yes, soon

@Someone-rj3vu 2 жыл бұрын

Hello Sir, loving the sessions. Could you also attach some practice questions along with the sessions if and only if possible. Also, thankyou for such easily explained insightful sessions.

@sumitmittal07 2 жыл бұрын

Will definitely try sharing the practice questions :)

@nikhilkotte3779 Жыл бұрын

@panththakkar7868 2 жыл бұрын

Hello sir , will you cover things like when to use index and how to optimise query performance

@sumitmittal07 2 жыл бұрын

Definitely in the upcoming sessions. Keep watching the series :)

@aashishmalhotra 2 жыл бұрын

11:00 doesn't know this syntax. Thanks

@stylewithanjudhanu4002 2 жыл бұрын

Could you please include Analytical functions and Pivot too

@sumitmittal07 2 жыл бұрын

Will be included in the upcoming sessions.

@satviktejas8716 2 жыл бұрын

WHERE CAN WE FIND THAT NOTEPAD WHERE YOU WRITING COMMAND SIR PLZ TELL

@sunilrao6090 5 ай бұрын

please help

@anabilmazumder3622 2 жыл бұрын

Sir, the sessions are well explained. But one imp. thing missing is practice data sets with practice questions. Could not find anyome atleast till session-6..

@sumitmittal07 2 жыл бұрын

Will try to provide a link to download the practice questions and data sets in the description.

@vishnujatav6329 2 жыл бұрын

Good session

@harshrajvaghela699 2 жыл бұрын

in previous video

@ARUNKUMAR-yn9uy 2 жыл бұрын

first view

@shreyashchoudhary6827 2 жыл бұрын

Can you provide the written notes ,which you write while explaining

@sumitmittal07 2 жыл бұрын

Will try including them in the description.

@satviktejas8716 2 жыл бұрын

can you plz provide the notepad 'sql course' we need to revise

@limitless365 2 жыл бұрын

One question, if I learn SQL, where I can find SQL related jobs? Does it possible to get a job If I only know SQL.

@vaibhavshrivastava5010 2 жыл бұрын

No ,You must know one programming language also.

@subhendukumarsingh7203 2 жыл бұрын

SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%\%ul'; SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%\_ul'; both are giving output "Empty set (0.00 sec)" but i have one record whose name ends with ul, that is rahul. Sir please Solve my Issues.

@navneet2649 2 жыл бұрын

yes both the statements will give empty set since both the statements which you have mentioned cannot return "rahul". If instead of 'rahul' you had 'rah%ul' or 'rah_ul' then you would got the desired results! For getting 'rahul' simply write : SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%ul';

@harshrajvaghela699 2 жыл бұрын

please sir reply my ducts

@limitless365 2 жыл бұрын

I am continuing every episode regularly...

@sumitmittal07 2 жыл бұрын

Keep watching and upskilling :)

@satviktejas8716 2 жыл бұрын

where can we find the document which sir is preparing side by side?plz tell