SQL Tutorial 7: Group By, Having & ,Order By Clauses in SQL

[@mahesh97413]

Anyone can easily understand your lectures.. Explanation was amazing. Keep going..

[@mohammedbasitshuttari2097]

Excellent teaching sir, watched many other videos for SQl but this is the best.

[@sdetpavan]

Thanks

[@sharadjogdand5332]

After watching many videos on you tube also after joining testing class not get clear idea but watching this video i clear my all dout. Thanks sir

[@Addistoday]

❤from Ethiopia, i owe you one🏆🏆🏆

[@sureshpatil3045]

I am your big fan, all the videos and training is amazing. you explain very well in detailed. Thanks for helping everyone :)

[@sdetpavan]

My pleasure!

[@saisruthi8201]

​@@sdetpavan HI sir, could you please share the notes of this sql playlist.

[@v2factsand327]

Just because of your videos I learned all selenium automation including Jenkins

[@nishantsharma6435]

i'm 100% sure if someone follow this video or watch this video only once definetly clear all the doubt what a beautful way to understanding topics like where, group by, having and order by.

[@rajprajapati7697]

sir... 🙏 your explaination is too Good. Thank you for making such videos

[@santoshgaykwad1997]

You are too good I have no words to describe your knowledge.

[@sdetpavan]

Thank you so much

[@roshanraut3093]

Hats off....................................Amazing practical teaching methodlogy.

[@saanvivlogs2517]

Sir, you have a very good knowledge in Sql the way you explain it's really easy & simple everyone can understand. Much appreciated

[@sdetpavan]

You are most welcome

[@sonalipatel2239]

thanku sir all playlist are very precisely explained by you ..i have a question do you provide the notes of these lectures? ,that will be very beneficial for us 🙏🙏

[@mayurivmulje1407]

You made it very easy for us. I am Much Grateful to you!!

[@sdetpavan]

Glad to hear that

[@shavezalam9086]

You are great sir kindly provide us sql file so we can practice the same queries biggest thanks to you sir❤

[@sandeshcs3966]

thank u very much sir ,I am really enjoying with this concept. Please carry these good work.

[@mannahidruhidru812]

just amazing way of explanation,God bless you

[@mandaprashanth8081]

Sir if you don't mind can you please share me the my sql data set that you have used in the video. That helps me alott

[@lokeshp1929]

Need that employee and hr databases to practice, those databases are not in the link that you given in previous video... Pls provide us the databases.sir

[@prayagrajchaudhary2270]

Sir best and complete explanation

[@sdetpavan]

Thanks

[@satyaverna9330]

very detailed explanation.your video deserve much more views

[@sdetpavan]

Thanks

[@Indiancricket25620]

thanku so much sir🙏 u are the best teacher

[@sdetpavan]

Welcome

[@v2factsand327]

Khatarnaak video's

[@tariqhashim9262]

Thank you sir for this simple explaining you make for us

[@sdetpavan]

Welcome

[@harikrishnan6208]

Excellent , Thank you so much Boss , Happy Diwali

[@sdetpavan]

Welcome

[@chandrakantsingh2303]

very nice concept sir .. thank you so much sir

[@sdetpavan]

Welcome

[@aleksandar.wolverine]

Great tutorial. Thank you!

[@sunkanaboinahari9537]

Very good explanation sir

[@sdetpavan]

Thanks

[@surajghogale]

Your are amazing teacher

[@sdetpavan]

thanks

[@saipothinas4681]

Thank you for excellent teaching. Much appreciated.

[@sdetpavan]

most welcome

[@keshavbhagat8318]

Very Thankful to You Sir 🙏

[@sdetpavan]

Welcome

[@NaveenPalanki-n4b]

can you please provide me the data set that you have used in this video

[@ppss972]

Excellent sir. Thanku

[@sdetpavan]

Most welcome

[@kunnudev7250]

Great job please continue awesome videos bro

[@sdetpavan]

Thanks

[@rajabhargavi697]

Amazing class. Thank you my god

[@sdetpavan]

most welcome

[@shubhangiraut1861]

you are amazing sir

[@sdetpavan]

thanks

[@musicislost]

New to this.. so count(*) is after column name or does it mattee?

[@yugandharbabu2790]

Good video 👌

[@sdetpavan]

Thanks

[@anantharamdevarakonda258]

SQL Mastering is made easy. No technical skills required. do more videos

[@rajukanuri5122]

Hi sir... My query is..... Get 2nd highest from each group. Is it possible in grouping

[@RapJunkie]

can we swap WHERE and HAVING in a query? Will it give same result?

[@shivachary6764]

Tq sir for clear cut explanation 👌👌

[@sdetpavan]

You're very welcome!

[@satishnavgire8990]

Thanks sir I have really enjoyed this session

[@bowenrylan5873]

you all probably dont give a damn but does anyone know of a method to get back into an instagram account? I was stupid lost my account password. I would appreciate any assistance you can give me.

[@briardamon9291]

@Bowen Rylan instablaster :)

[@bowenrylan5873]

@Briar Damon I really appreciate your reply. I found the site thru google and Im waiting for the hacking stuff now. Looks like it's gonna take quite some time so I will get back to you later with my results.

[@bowenrylan5873]

@Briar Damon It did the trick and I finally got access to my account again. I'm so happy:D Thank you so much you saved my account!

[@briardamon9291]

@Bowen Rylan glad I could help :)

[@sadafoad205]

nice video. I have question .if we want to print data only for specific dept.. like how many employees specially working in in IT dept?

[@sailakshman3088]

select job_id,count(*) from employees where job_id="IT" group by job_id;

[@romanyakymets738]

Thank you very much !

[@sdetpavan]

You are welcome!

[@tejasagni371]

very helpful. Thanku

[@sdetpavan]

Welcome

[@muhammadjunaidmajeed1211]

Excellent!

[@sdetpavan]

Thanks

[@saranyab2304]

There is a column with array of values in athena table...eg) col A row A has value like [{a:1,b:2},{a:3,b:4}] like this. I want to fetch rows which a has 1.how to write query for this.kindly help

[@shivanshusharma20.07]

If we cannot use your data and table how we will practise? From where can i get your sql table and its data please???

[@srihari-dn1eu]

nice video

[@sdetpavan]

Thanks

[@alexanderschannel6198]

What did you say 8:00-8:10 couldn’t quite hear thank you 🙏

[@venkateshnaidu1212]

Sir can you please provide the link of this document.

[@simplestarview3376]

Thanks you 💖💖💖 sir

[@sdetpavan]

Most welcome

[@yuviarts8475]

thankyou so much

[@sdetpavan]

Most welcome

[@BasavarajShellikeri00]

Sir where I can get that ppt you're sharing in the video.

[@umairunc7053]

THANKS SIR . NEED DATA OF HR

[@sdetpavan]

Welcome

[@saranyachandrabos3541]

Thank you sir

[@sdetpavan]

Most welcome!

[@shilnajohn61]

Good class

[@feovadimka]

Thank you!

[@sdetpavan]

Welcome!

[@shuvamdebbarman5113]

how to insert null entries in a table OR adding a row and filling its datas???

[@academicnexus3712]

Hi sir, how to get the lectures slides?

[@rajkumarsamala2418]

Sir we want your hr data sir for practicing

[@AvanthikaAlladurgam]

sir can you please provide your ppt

[@santhoshkumar7816]

How to get last row using group by and having clause from a group

[@sivalankabhanuprakash3174]

Sir at time 6:03 average salary is in decimals upto 5 digits how to reduce to 2 decimals in same query.

[@gviswanadh1845]

you can apply Truncate for that column, how to download hr database?

[@sivalankabhanuprakash3174]

@@gviswanadh1845 THANK YOU SIR FOR REPLYING AFTER 1 YEAR

[@gviswanadh1845]

@@sivalankabhanuprakash3174 welcome bro am seeing videos now only.

[@Avirajvlogs8]

SIR i want notes will you please send any link] '

[@rony11888]

what should be data type for phone_number in employees table..anyone know pls reply on this

[@khwajatruly]

phone_number Number(10)

[@UttrakhandPahadiBoY1]

Coukd you please send this sql data.

[@KaranChaunwal]

IT field k khan sir

[@sdetpavan]

My pleasure

[@bharathenishetty1550]

21:00

[@omvanjani]

😊

[@metehand8838]

thank you sir

[@sdetpavan]

Most welcome