MYSQL COMMANDS (PART-7) ORDER BY | GROUP BY | HAVING CLAUSE | CBSE CLASS XII | COMPUTER SCIENCE

[@akshyajain1664]

Yup!my doubts are crystal clear 😘

[@SwatiChawlaofficial]

Great.... Thank you.. Keep watching..

[@aviralsaxena2650]

Thanks a lot ma'am. Not a single youtuber explained this with examples but you did and made this crystal clear. Huge respect for you.

[@SwatiChawlaofficial]

My pleasure 😊

[@youknowme3482]

Itni confusion thi , all clear , thanksssss

[@SwatiChawlaofficial]

That's Great..😊 Keep Watching..👍🏻

[@shreyhere7688]

Ma'am you should teach in physics wallah platform. It'd really be a boon for all the cs students

[@infinity2449]

honestly ,i was thinking the same😁

[@sagarmishra7219]

I already commented about this in there recent video and found this comment here 😂😂😂

[@POOJAGUPTA-db8wq]

Yes mam

[@awesomeindians5301]

Yes...and I am a student of lakhshya batch 2023

[@ajju7778]

I was also thinking the same 😅

[@Dr.Anshu-vmmc]

Bhalle bhalle maja aa gaya shaaba shaaba samajh aa gaya ❤️ Thank you ma'am.....ab pata chala ki csc itni aasan hai.. 💫❤️❤️🌟🤗

[@SwatiChawlaofficial]

Thanku.. Glad it helped!!!

[@adirajv3195]

It is the toughest topic for me but u taught it very simply. Thank you❤🌹🙏 very much😊

[@SwatiChawlaofficial]

Thanks and Welcome

[@priyanshukumarsingh6240]

Thankyou so much mam you don't know how much you have helped us and will help in future

[@SwatiChawlaofficial]

Thanks and Welcome 🙂

[@narayansinghtomar3250]

Mam I m pressing like button in every vidio which I had watched because u teachs in very simpe way

[@SwatiChawlaofficial]

Thank you so much 😀

[@rajveerkaurbhangu5351]

Thnxx 🙏a tonnn mam😊✨✨✨.....for clearing all my doubts.....🤷‍♀️🤷‍♀️

[@SwatiChawlaofficial]

Most welcome 😊

[@motivationalstrategypriyan2877]

My all doubts are Crystal clear.... Thank you so much ma'am... Really ur teaching style is tooooo good......😍🌹

[@SwatiChawlaofficial]

Thanku so much.. 🙏🏻🙂

[@PushpendraKumarmundotiya]

Thanks mam aap jesa hona chaiye teacher

[@SwatiChawlaofficial]

Welcome

[@SuhailJee-h4x]

FINALLY I GOT THE BEST C.S CHANNEL........... VERY VERY HELP FULL ......... THANK YOU SOO MUCH MEM I SAW ALLL 7 PARTS OF SQL...!!!!!!!! IF POSSIBLE CAN YOU MAKE 2024 2025 THIS YEAR NEW VIDIOS,,,,,,,,OR PARITICS QUSTAINS PLEASE MAMMMMMM>>>>>>//// THANK YOU SO MUCH LOVE IT !!!

[@SwatiChawlaofficial]

Thanku so much... 🙂🙏🏻 Please check out the following link for new videos.. kzbin.info/aero/PL5Raijva2y4Qtq23KCz6VRdPQ4NUtrmuI&si=vBiiP6aVjdkQvk6j

[@aditi_1A.]

Yoo.... crystal clear 🥳🌹🌹

[@mehak5968]

THANK U SO MUCH MAAM FOR THIS HEARTFULL TEACHING .....ALL THE CONCEPT BECOME CRYSTAL CLEAR AFTER SEEING UR VIDEO ONCE.😍😍😃😃

[@SwatiChawlaofficial]

Great... Golden it was helpful.. Thanku so much 🙂🙏🏻

[@islamiceditz5399]

Thank You very muchh ma'am Excellent work and Great 👌 Awsm notes

[@SwatiChawlaofficial]

Thanku

[@RakhiSharma-pw9oz]

Very good video mam keep it up and thank you once again for help

[@SwatiChawlaofficial]

Thanks and welcome

[@yatinsaini1456]

superb videos mam i had confusion in group by, having and where command for a long time

[@SwatiChawlaofficial]

Thanku... Hope it's clear now..

[@RaviKumar-ng1fo]

Crystal clear ,thanks so much mam 😍😍🥰🥰😇😇😇🤗🤗🤗

[@SwatiChawlaofficial]

You are welcome 😊

[@yogeshbaghel6745]

thankyou apke bjhe se cs achhi lgne lgi

[@SwatiChawlaofficial]

that's great.. thanku so much.. keep watching..

[@srauto6070]

Mam your teachings are really awesome ...keep on going.Thank You

[@SwatiChawlaofficial]

Thanks a lot

[@Dazelsea]

Best and calm explanation ❤️🙂

[@SwatiChawlaofficial]

Thanku

[@mrwordpress6676]

Very nice maam keep doing this hard work and concepts are crystall clear 👍👍👍👍👍👍👍

[@SwatiChawlaofficial]

Thank you, I will

[@shalini9tha437]

8:53 mam how the table got arranged when 2 rows have salary 45000?

[@OjasviJagtap1105]

Thank you so much mam..you explained very well. I have watched many videos but your video cleared me all concepts ❤

[@SwatiChawlaofficial]

Thanku 🙂

[@kushal6635]

Literally maja aagya mam!!! 👍❤

[@SwatiChawlaofficial]

Thanku

[@Auxin11.11]

Thank you so much mam I was finding one perfect channel for my board exam I got it ... If I get good mark all because of you thank you I will tell on 15 July how much I get .... Thank you love you mam you will get more subscribers soon thank you so much once again ❤️❤️❤️❤️

[@SwatiChawlaofficial]

so nice of u... Thanku so much...

[@ankitkumar17g]

How much you get

[@Auxin11.11]

@@ankitkumar17g 86 🙌

[@SA-so2zc]

@@Auxin11.11 medico ?

[@rehanbatham392]

Very easy and ecxccelent. Explanation

[@SwatiChawlaofficial]

Thank You so much..😊🙏🏻

[@ayushsharma6401]

Superbly explained ma'am thank you so much

[@SwatiChawlaofficial]

Thanks and Welcome

[@manojdongre8174]

Wonderful video mam Cleared My doubt ❤️

[@SwatiChawlaofficial]

Glad to hear that Thank You!

[@ashwin3475]

Thanks so much ma'am....Good teaching ❤️❤️❤️

[@SwatiChawlaofficial]

Thanks and Welcome

[@nadinerembuellamsoru771]

thug life to those who see this viedo during the exam day morning

[@kartavya5085]

💪💪 #pass hona hai aaj

[@amulmast9099]

Life saving channel 🙏🙏🥶🥶

[@SwatiChawlaofficial]

Thanku

[@pavneshyadav3469]

You are great ma'am 😊

[@SwatiChawlaofficial]

Thanku so much..😊🙏🏻

[@neha2763]

Every video lecture is very nicely explained ❤️❤️❤️❤️

[@SwatiChawlaofficial]

Thankuu so much...🙏🏻😊 Keep Watching....👍🏻

[@kashish629]

Thankyou so much ma'am ☺️☺️🙏. Can u teach c++ also ? Just asking . Awesome lectures ...👍

[@cheshtabatra1828]

Crystal clear mam

[@SwatiChawlaofficial]

Thanku..

[@Teenu]

mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......

[@SwatiChawlaofficial]

Glad to hear that

[@sanskariboy2474]

Very easy and excellent explaination 🙏🙏🙏

[@SwatiChawlaofficial]

Thanku so much...

[@sanskariboy2474]

@@SwatiChawlaofficial well 😊😊

[@ananyasapahiya9938]

Tysm ma'am ❤️

[@Cute_solved]

Ma'am, you are a great teacher to me, who teaches us in the best way, this is a heartfelt thank you, and I also want to ask if you can send me a PPT of MySQL, its request of one of your students 🙏🙏🙏🙏🙏🙏🙏🙏🙏 , please...

[@SwatiChawlaofficial]

Thanks for appreciation.. Sure... You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@Cute_solved]

@@SwatiChawlaofficial MAM PLEASE PROVIDE THIS IS MY EMAIL ID [e-mail]

[@abrarahmad3897]

thanks ma'am, i got 100/100 in cs because of you.

[@SwatiChawlaofficial]

Great!! Congratulations...

[@aksm111]

Tips plz

[@satyamgupta2805]

In boards?

[@debasishdas6049]

Thank u mam this is great explanation i ever heard

[@SwatiChawlaofficial]

Glad to hear that Keep Watching

[@asthasrivastava9050]

You teach so well❤🙏

[@SwatiChawlaofficial]

Thanks

[@RituJindal-x7v]

Mam the pdf on library management you have provided on telegram channel does it includes python, sql, file handling, exception handling and connectivity

[@areeb3663]

Thank you so much mam! prayers from pakistan!!

[@SwatiChawlaofficial]

Thanks and Welcome

[@VardhanMittal]

Mam in order by clause null values always come in first in ascending or descending order

[@SwatiChawlaofficial]

in ascending order NULL will be at top... in descending order, NULL values will be at bottom...(for the column in which u r applying order by)

[@shivamsalaria7487]

My sql is case insensitive.. So is there will be any problem if i write anything in small or capital letters according to my wish? While doing program

[@SwatiChawlaofficial]

No..no problem... it's just a convention

[@mythsvsfacts9942]

Yes my concepts are crystal clear ❤️

[@SwatiChawlaofficial]

Great

[@kvd974]

Thanks mam , it was very informative

[@SwatiChawlaofficial]

My pleasure 😊

[@saumyasingh...8441]

Nice explanation mam

[@SwatiChawlaofficial]

Thanks a lot

[@riyapathania5081]

Thankyou soo much 😭❣️❣️❣️❣️❣️

[@sonali6919]

Yes miss it was very much clear but I want explanation of count fn with distinct as it is in sumita arora . Thank you miss for lucid teaching

[@SwatiChawlaofficial]

Count( distinct attribute)) will count the distinct values in an attribute

[@dallygupta5083]

Thankuu for this perfect vedio ❤️

[@SwatiChawlaofficial]

Most welcome 😊

[@swetasharma-g9m]

hloo maam, firstly i would like to say thank uhh so so much for teaching us such in incredible way......maam i hv prblm in making programming wht should i do ??????bta dijiye plzz maam......

[@SwatiChawlaofficial]

kzbin.info/www/bejne/eGmwp2aOhMx9r7csi=eUDhSVNMHKNC4-kV

[@wittyvlogs8499]

thanks now it feels very easy! thankyou!

[@SwatiChawlaofficial]

My Pleasure..

[@nikitajoel1146]

Thank you sm💜 I wish you were my teacher 😭

[@SwatiChawlaofficial]

Most Welcome

[@TunerXMusic4u]

Platinum clear 😃🤠🤠🤠😃

[@SwatiChawlaofficial]

That's Great . Thanku.. Keep Watching

[@TunerXMusic4u]

@@SwatiChawlaofficial yes of course

[@eddy18457]

@@SwatiChawlaofficial great series ma'am thank you

[@hanadulsethuh2253]

I have a doubt Can we write SELECT COUNT ( debt) from emp GROUP BY dept Like this?

[@gauravtomar6695]

yes, you can write it like that if there is no null value in dept. If there is a NULL value then the count of NULL will be shown as 0 even if there are many NULL values in debt. So count(*) is better to use in any case.

[@MohitSingh-qr5fl]

Goodevening mam Select count (empno)From empl1 Group by deptno ; Mam what will be the and of this statement ..here empno,deptno is column name ....

[@MohitSingh-qr5fl]

Mam i have many que to ask but don't know how it will be possible 😭😭

[@krishnapriyad9689]

Well explained mam 👌

[@SwatiChawlaofficial]

Thanks a lot

[@travelersokk6510]

Mam can we use where condition in group by query

[@SwatiChawlaofficial]

Having is used with group by

[@travelersokk6510]

Ok mam thanku

[@ProGamer-fk2tc]

ma,m I have a doubt... the answer to an order by command was- Select COMPANY, PNAME from PRODUCTS order by COMPANY; so my question is mam why do we have to write order by company and why r we not writing PNAME with it?? Also, it was not mentioned in the question either

[@SwatiChawlaofficial]

After order by...you have to write the name of the column, which you want to sort

[@ProGamer-fk2tc]

@@SwatiChawlaofficial ty mam

[@innovative2966]

Nice video thanks Ma'am

[@SwatiChawlaofficial]

Thanks for liking

[@sweetpanda4370]

*doubt here!* Hi mam Suppose we want to count how many males and females have taken arts. So i wrote the query Select gender, count(*) from xii Group by gender Having stream='arts'; Where xii is table name It shows error "unknown column stream in having clause Why.. Select

[@yogeshpandey1837]

Brother you cannot use = in this command it is not correct. Rather you must use like operator. So the code will be like Having stream like (arts).

[@2K_GAMINGX]

@@yogeshpandey1837 YE BHI GALAT H NHI KRRHA KAAM

[@2K_GAMINGX]

GROUP BY GENDER,STREAM HAVING STREAM = 'ARTS'; THIS IS THE RIGHT QUERY. THANKYOU KE SATH PUPPI JRUR DENA

[@Handle1947]

@@2K_GAMINGX umma le bhai puppi

[@yashyashkumar6506]

I subscribed you channel mam I want to see your 1 lakh subscribers soon😊

[@JokarBhai1]

me too...

[@ronitkumar4619]

Congrats

[@adityaranjan9662]

Amazing session....

[@SwatiChawlaofficial]

Thanks

[@AdarshKumar-hi6vu]

Ma'am If we apply these command(order wise, group wise) Will it affect the original table.

[@SwatiChawlaofficial]

No

[@mangoking4310]

Nice explanation

[@SwatiChawlaofficial]

Thanku

[@islamiceditz5399]

Crystal clear 😊

[@SwatiChawlaofficial]

Thanku

[@AmitDas-nw6ux]

Mam aap kon si kv ki ho

[@shubhangam2119]

tnx tommorow is my exam

[@SwatiChawlaofficial]

Welcome.. Best wishes for your exam

[@shivamsalaria7487]

Mam is it necessary to write "order by, group by" in capital letters?

[@SwatiChawlaofficial]

No.. it's a convention

[@justforfun-vh9ek]

TQ mam it clears all my doubts

[@SwatiChawlaofficial]

Welcome

[@harshikasharma6580]

mam can you please tell the difference between group by and distinct

[@harshitgupta7073]

Group by me department me jitne log hai sbka name chahiye Kse krenge mam ? Ex . IT | 2 | Sonya , Rahul

[@Ravi-zi2ti]

best.....

[@SwatiChawlaofficial]

Thanku..

[@arjunyadav507]

thank you soo much ma'am 😊😊😊

[@SwatiChawlaofficial]

Welcome

[@sahiltiwari3970]

11:46 pe mam apne to group by dept kr rakha hai yha but 11:47 me wo alphabetical order me group kyu nhi hua hai ... Phele Null ana. Chaiye Fir finance , marketing , purchase , sale Group by dept ke hisab se

[@priyankakhobragade3254]

bhai original table ke order me aata hai voh, go to 4:20 and see waha original table ke order me result aata hai, aur humne yaha order by use nahi kiya hai toh doesn't matter ki result mein alphabetically aaye, Hope It helped you :)

[@sahiltiwari3970]

@@priyankakhobragade3254 ok thank you sister ....🙏😊

[@priyankakhobragade3254]

@@sahiltiwari3970 welcome bhai❤💪😁😊Goodluck for exams

[@adityasarswat3891]

Thankyou mam for your help!!

[@SwatiChawlaofficial]

Welcome

[@sonysony-fn5ci]

HOW WE cn know total amount to pay monthly salaries of all emps in that department as sal is more than 9000

[@nayanv80]

Please write the syntax How to map the count of students having backlogs at a particular age

[@raiant4297]

If we want the output to be in order, group wise & having condition also.. How will order by, group by &having clause be written in this type of case ? Can we use all of them simultaneously ?

[@SwatiChawlaofficial]

select stream,count(*) from student1 group by stream having count(*)>=4 order by stream desc;

[@raiant4297]

@@SwatiChawlaofficial Thanks mam 🤓, now no doubts left.. All clear

[@vanyasingh3rda503]

I have a doubt ... Can we not make a group by command without using an aggregate function?

[@zackydev]

yes, something like `select * from student group by gender;` would work

[@kingjoel402]

Thanks ma'am!!

[@SwatiChawlaofficial]

Welcome

[@snehalshahi]

Hello mam, I have a doubt while performing orderby on more than one column for ex: select * from emp order by stream asc, ename desc; then what will the result be?

[@SwatiChawlaofficial]

First it will sort the stream in ascending order, then within each particular stream enmae will sorted in descending order... I have explained this in one of my videos as well 🙂

[@snehalshahi]

@@SwatiChawlaofficial alright mam thank you, I had a doubt in this topic hence referred to this particular video. Thank you for clearing the doubt 😊

[@SwatiChawlaofficial]

Welcome

[@manvirsingh1245]

Mam what is the difference if we use count(*) and count() ???

[@SwatiChawlaofficial]

Explained in this video.. kzbin.info/www/bejne/l3nMYpernZeXis0

[@arpitakumari7250]

Can i ask you a question of exam

[@ranita5599]

Mam name kya alphabetically order hoo rahe hai

[@SwatiChawlaofficial]

it will sort that column, on which you apply ORDER by command

[@VardhanMittal]

Mam thank you so much

[@SwatiChawlaofficial]

Most welcome 😊

[@jayprakashprasad8541]

Thanks a lot

[@rohitnegi6990]

done!!

[@somilbansal516]

understood

[@SwatiChawlaofficial]

Thanku🙏🏻👍🏻

[@anshujais]

Thank u Mam well taught 🤗

[@AjeetKumar-hv5up]

Thanks mam

[@SwatiChawlaofficial]

Welcome...🙏🏻😊

[@anshikagrover2322]

Mam if in grop by we have to use any other name in the output instead of count(*) then what will be the query ??

[@SwatiChawlaofficial]

Check out the explanation of scalar expression..

[@anshikagrover2322]

@@SwatiChawlaofficial mam can we also use aliasing command for this ??

[@sagarmishra7219]

@@anshikagrover2322 e.g select sname, count(*) as "count" from student group by sname

[@harbanslalmandal7350]

Mam as term -2 will be subjective. Mam can u give link for subjective questions answers. So that it will be quite helpful

[@SwatiChawlaofficial]

Already uploaded.. Please check out the respective playlist..

[@Thakur_Roshan]

Thanks ma'am

[@SwatiChawlaofficial]

Most welcome 😊

[@VardhanMittal]

Mam count function includes duplicate value??

[@SwatiChawlaofficial]

kzbin.info/www/bejne/l3nMYpernZeXis0 Check out this

[@VardhanMittal]

@@SwatiChawlaofficial mam I have seen this video from that only i ask

[@SwatiChawlaofficial]

Yes...count function will count duplicate values also.. If u want to count duplicate values once, use distinct with count

[@VardhanMittal]

@@SwatiChawlaofficial ok mam tnx

[@vinit173]

Thanks...

[@SwatiChawlaofficial]

Welcome

[@anshulrajput7286]

Mam thanku

[@SwatiChawlaofficial]

Welcome