Limit + Aliasing in MySQL | MySQL Beginner Series

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Limit and Aliasing in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

[@BeanWorks91]

Aliasing is one of the best methods to reduce keystrokes!! This is perfect 🎉❤

[@stephenpeterwandera9176]

Amazing! I have learnt a lot in such a short period of time and I am confident in the prospect of working on projects!

[@Imariml]

Thank you this course helped me realy

[@TheStoicWay110]

Amazing, Thank u so much Sir ALEX

[@preetshah3793]

Make a video on statistics for data analysis

[@user-kq3tc5tu1c]

Great refresher on both LIMIT and ALIASING. For example, I don't think I've ever come across the whole "limit a certain number of rows" THEN "return the NEXT row" technique before. Wow, I knew I had a lot to learn and, in some cases, relearn... Good thing you have the Intermediate & Advanced lessons ready for me when I get there. Keep this up and you're going to get a Christmas card! Cheers

[@qamaruddinkhichi904]

Hey Alex thanks a lot for making SQL easy for us. I have a question Alex, when are you going to make videos on Intermediate and Advanced series on MySQL. And any projects on MySQL??

[@mgbechetapaschal609]

I am enjoying learning this course ok here so far 😊😊 but I am sorry Alex I currently can’t afford it on analyst builder 😢

[@wisdomodudu4154]

Thank You alot, when should we expect the playlist for the intermediate and advanced for mysql

[@bezawitdesalegn1113]

Thank you so much Alex it is helpful. Sorry Alex I have a question regarding the Bootcamp course I have started taking course do I have to complete all courses to get the certification of completion thank you in advance

[@akshatau3005]

Hi, I have a question- Is having clause executed before SELECT? If yes, how does aliasing works in the example you showed in the video? Thanks

[@zeusignap1477]

Comment for algorithm, thanks for sharing!

[@checkthenotes]

Hey Alex, I want to ask something, If we can find the oldest, how about if we need the top 3 oldest and the top 3 youngest person in one table? hope you notice my question. thank you!

[@chuky422]

Can you extend your code 20% off. I thought it was on your website but i couldnt find it on which video it was on

[@bunniesanchez2225]

So why mysql vs mssql?

[@StasLeo1987]

Select top 5 = limit 5? By the way, HAVING is in your intermediate level, as far as I remember.

[@inshakhan3356]

If you are going to use MYSQL then why did you let us install SSMS, The limit clause doesn't work in SQL server.

[@gunnereshzurale8843]

Use TOP, same purpose