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

[@sumitmittal07]

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

[@santoshsable1]

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. ..!!

[@yashdhas8202]

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

[@sumitmittal07]

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

[@thakurmanu7102]

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.

[@rokibhasan5184]

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.

[@gauravrajauria9460]

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

[@sumitmittal07]

Yes, soon

[@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.

[@_insanebuddy]

Thanks sumit sir ! This series is amazing .

[@sukantabala2514]

Very good turorial.

[@aparoopsaha8477]

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]

Definitely, as soon as possible

[@Someone-rj3vu]

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]

Will definitely try sharing the practice questions :)

[@poojag4335]

Loved it

[@ningus8522]

thanku sir..

[@karthikeyankarthik4752]

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

[@dilawarjalil8842]

Thanks Sir

[@hrishipal3567]

Crazy good❤

[@itsme1674]

Amazing lecture

[@drspark123]

Thank you sir ..

[@panththakkar7868]

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

[@sumitmittal07]

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

[@anabilmazumder3622]

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]

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

[@vinaykumar-oc7ev]

Which recording sw are you using?

[@stylewithanjudhanu4002]

Could you please include Analytical functions and Pivot too

[@sumitmittal07]

Will be included in the upcoming sessions.

[@limitless365]

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]

No ,You must know one programming language also.

[@somethingmeaningful]

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

[@AGRIMTYAGI14]

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

[@shashankarya9481]

where can i find this notepad file?

[@satviktejas8716]

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

[@sunilrao6090]

please help

[@vishnujatav6329]

Good session

[@nikhilkotte3779]

Hi Sir, I got the output for below query which you got error. mysql> SELECT DISTINCT source_of_joining FROM students ORDER BY enrollment_date DESC LIMIT 5; +-------------------+ | source_of_joining | +-------------------+ | friend | | youtube | | google | | quora | | linkedin | +-------------------+

[@aashishmalhotra]

11:00 doesn't know this syntax. Thanks

[@subhendukumarsingh7203]

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]

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';

[@ARUNKUMAR-yn9uy]

first view

[@harshrajvaghela699]

in previous video

[@shreyashchoudhary6827]

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

[@sumitmittal07]

Will try including them in the description.

[@satviktejas8716]

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

[@architkumar1265]

Smash the like for "LIKE Keyword"...👊🏻👍🏻

[@limitless365]

I am continuing every episode regularly...

[@sumitmittal07]

Keep watching and upskilling :)

[@satviktejas8716]

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

[@harshrajvaghela699]

please sir reply my ducts

[@divyanshujha3908]

Sir, can you please add a text file containing all the records, so that we can practice ourselves. Thank You