Limit + Aliasing in MySQL | MySQL Beginner Series

[@BeanWorks91]

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

[@abhishekpatil1304]

If you give assignment questions and answers on each topic it will be very helpful for us to practice

[@GoGetSP]

Completed the beginner series. Alex thankyou so much. Feels like a huge accomplishment. 🙏

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

[@joshgreeley3707]

everytime I hear the outro I feel like I accomplished something

[@krishnakarma6166]

Hey Alex! I'm new to this channel and soo far I'm really enjoying your teaching procedure,but can you add some assignments to practice after each lesson as well? It will really help us.

[@mbmathematicsacademic7038]

Thank you Alex, I had knowledge of SQL but not application. I binged the MySQL basics

[@preetshah3793]

Make a video on statistics for data analysis

[@Imariml]

Thank you this course helped me realy

[@BruceBeck-f1n]

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

[@BBtechnology]

Sir this course is on point i can imagine your premium courses.

[@mattdawg2469]

Great Course !

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

[@chooselife2388]

Thanks Alex

[@TheStoicWay110]

Amazing, Thank u so much Sir ALEX

[@wisdomodudu4154]

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

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

[@shahafkhan9295]

You are an amazing person

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

[@zeusignap1477]

Comment for algorithm, thanks for sharing!

[@abdisalanmuhumed6135]

thank you very much

[@RZVERT]

I wish there was a way to test what we learned with assignments for free for these

[@ahmedshukrow2995]

My thought also!

[@Rizzistor347Mars]

@@ahmedshukrow2995 go pay broke mandem

[@shubbhamarya]

solve problems on hackerrank

[@NohablaEspnaol]

Thank you sir :)

[@hosameldean5478]

I love you man

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

[@unusuariocomun8281]

- LIMIT 3,2 como funciona?
El primer numero el 3 omitira los 3 primeros resultados y me dara solo los dos siguientes

[@irdcs]

Should I go through the beginner series a couple extra times before I move on? it feels too quick for someone like me with zero previous knowledge.

[@favouruwidia2469]

You should consider taking W3schools sql course, then come back to this. It’s not in video format though but it’s very beginner friendly and it’ll definitely make it easier when you come back to these videos.

[@irdcs]

@@favouruwidia2469 thank you so much!

[@marcelaa.7112]

@@favouruwidia2469 is it paid or free?

[@Abzarad]

3:10 the example is not clear, how average age and less than 40? I also did not understand where did the females go, disappearing from the output? Please explain. This GROUP BY is driving me crazy.

[@RakibulHoque666]

Less than 40 will eliminate males as more than 40 eliminated females because avg(age) for female is

[@clarke6814]

✅complete

[@Mr.Arshad-oc1fd]

The beginners SQL course is not enough for most business activities

[@JorgeFlores-ti6wg]

But it’s started off leaning basics correct

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

[@RakibulHoque666]

Why does Deputy Director Leslie Knope makes more than Director Ron Swanson?

[@hilalyld3505]

limit does not work in MS SQL. Do you think, why? What do you prefer, TOP statement?

[@Olly434]

that's what I used bc it does the exact same thing but it doesn't work for the 3,1 example right after that

[@knygrs]

done

[@nomaanrizvi6561]

the limit 2,1 is not working in postgresql.............ERROR: LIMIT #,# syntax is not supported
LINE 15: limit 2,1;
^
HINT: Use separate LIMIT and OFFSET clauses. .................the following is the error........is it a postgresql issue?????

[@mikhattak]

I have the same issue, my system give me error when going for limit, it does not recognize, i can do with top function but not with limit function. do you have any luck on limit function?

[@nomaanrizvi6561]

@@mikhattak this actually does not support in postgreSQL

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

[@Motivational_hub_98]

1:24 I don't get that, what happened after using limit 2,1
what does it mean??

[@Subst4nce12]

it displays just the next person after the top 2, so if the record have aaron, adrian, and ben... it will only display ben's record

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

[@scrunchiestylepk]

hello there are 2 courses in his channel you probably watch ssms one , otherwise in thsi course he asked us to isntall mysql