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 !!!
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...
Thanks for appreciation.. Sure... You can enjoy special perks by joining the membership. Have a look at this. ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
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 ❤️❤️❤️❤️
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.
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......
*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
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
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 ?
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?
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 🙂
Yup!my doubts are crystal clear 😘
Great....
Thank you..
Keep watching..
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.
My pleasure 😊
Itni confusion thi , all clear , thanksssss
That's Great..😊
Keep Watching..👍🏻
Bhalle bhalle maja aa gaya shaaba shaaba samajh aa gaya ❤️ Thank you ma'am.....ab pata chala ki csc itni aasan hai.. 💫❤️❤️🌟🤗
Thanku..
Glad it helped!!!
Ma'am you should teach in physics wallah platform. It'd really be a boon for all the cs students
honestly ,i was thinking the same😁
I already commented about this in there recent video and found this comment here 😂😂😂
Yes mam
Yes...and I am a student of lakhshya batch 2023
I was also thinking the same 😅
It is the toughest topic for me but u taught it very simply. Thank you❤🌹🙏 very much😊
Thanks and Welcome
Thankyou so much mam you don't know how much you have helped us and will help in future
Thanks and Welcome 🙂
Thnxx 🙏a tonnn mam😊✨✨✨.....for clearing all my doubts.....🤷♀️🤷♀️
Most welcome 😊
Mam I m pressing like button in every vidio which I had watched because u teachs in very simpe way
Thank you so much 😀
Thank You very muchh ma'am
Excellent work and Great 👌 Awsm notes
Thanku
Thanks mam aap jesa hona chaiye teacher
Welcome
My all doubts are Crystal clear....
Thank you so much ma'am...
Really ur teaching style is tooooo good......😍🌹
Thanku so much.. 🙏🏻🙂
thankyou apke bjhe se cs achhi lgne lgi
that's great..
thanku so much..
keep watching..
Thankyou mam😊
THANK U SO MUCH MAAM FOR THIS HEARTFULL TEACHING .....ALL THE CONCEPT BECOME CRYSTAL CLEAR AFTER SEEING UR VIDEO ONCE.😍😍😃😃
Great...
Golden it was helpful..
Thanku so much 🙂🙏🏻
Crystal clear ,thanks so much mam 😍😍🥰🥰😇😇😇🤗🤗🤗
You are welcome 😊
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 !!!
Thanku so much... 🙂🙏🏻
Please check out the following link for new videos..
ruclips.net/p/PL5Raijva2y4Qtq23KCz6VRdPQ4NUtrmuI&si=vBiiP6aVjdkQvk6j
superb videos mam i had confusion in group by, having and where command for a long time
Thanku... Hope it's clear now..
Very good video mam keep it up and thank you once again for help
Thanks and welcome
Thank you so much mam..you explained very well. I have watched many videos but your video cleared me all concepts ❤
Thanku 🙂
Mam your teachings are really awesome ...keep on going.Thank You
Thanks a lot
Superbly explained ma'am thank you so much
Thanks and Welcome
Very easy and ecxccelent. Explanation
Thank You so much..😊🙏🏻
Best and calm explanation ❤️🙂
Thanku
Yoo.... crystal clear 🥳🌹🌹
Very nice maam keep doing this hard work and concepts are crystall clear 👍👍👍👍👍👍👍
Thank you, I will
Thanks so much ma'am....Good teaching ❤️❤️❤️
Thanks and Welcome
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...
Thanks for appreciation..
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
@@SwatiChawlaofficial MAM PLEASE PROVIDE THIS IS MY EMAIL ID itsmekk914@gmail.com
Wonderful video mam
Cleared My doubt ❤️
Glad to hear that
Thank You!
Literally maja aagya mam!!! 👍❤
Thanku
Tysm ma'am ❤️
Crystal clear mam
Thanku..
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 ❤️❤️❤️❤️
so nice of u...
Thanku so much...
How much you get
@@ankitkumar17g 86 🙌
@@Auxin11.11 medico ?
mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......
Glad to hear that
You are great ma'am 😊
Thanku so much..😊🙏🏻
Every video lecture is very nicely explained ❤️❤️❤️❤️
Thankuu so much...🙏🏻😊
Keep Watching....👍🏻
Life saving channel 🙏🙏🥶🥶
Thanku
thanks ma'am, i got 100/100 in cs because of you.
Great!!
Congratulations...
Tips plz
In boards?
Thank u mam this is great explanation i ever heard
Glad to hear that
Keep Watching
Thank you so much mam! prayers from pakistan!!
Thanks and Welcome
thanks now it feels very easy! thankyou!
My Pleasure..
Very easy and excellent explaination 🙏🙏🙏
Thanku so much...
@@SwatiChawlaofficial well 😊😊
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
No..no problem... it's just a convention
Yes my concepts are crystal clear ❤️
Great
Nice explanation mam
Thanks a lot
Thankuu for this perfect vedio ❤️
Most welcome 😊
Thanks you mam
You teach so well❤🙏
Thanks
Thankyou soo much 😭❣️❣️❣️❣️❣️
Thankyou so much ma'am ☺️☺️🙏.
Can u teach c++ also ? Just asking . Awesome lectures ...👍
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
Count( distinct attribute)) will count the distinct values in an attribute
Platinum clear 😃🤠🤠🤠😃
That's Great .
Thanku..
Keep Watching
@@SwatiChawlaofficial yes of course
@@SwatiChawlaofficial great series ma'am
thank you
Thank you so much ma'am😇
Welcome
Thanks mam
Welcome..
Thanks mam , it was very informative
My pleasure 😊
Mam in order by clause null values always come in first in ascending or descending order
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)
Nice video thanks Ma'am
Thanks for liking
Thank you sm💜 I wish you were my teacher 😭
Most Welcome
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 ....
Mam i have many que to ask but don't know how it will be possible 😭😭
thug life to those who see this viedo during the exam day morning
💪💪 #pass hona hai aaj
I have a doubt
Can we write
SELECT COUNT ( debt) from emp GROUP BY dept
Like this?
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.
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......
ruclips.net/video/B8Mv3XOgJyU/видео.htmlsi=eUDhSVNMHKNC4-kV
Well explained mam 👌
Thanks a lot
*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
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).
@@yogeshpandey1837 YE BHI GALAT H NHI KRRHA KAAM
GROUP BY GENDER,STREAM HAVING STREAM = 'ARTS';
THIS IS THE RIGHT QUERY. THANKYOU KE SATH PUPPI JRUR DENA
@@2K_GAMINGX umma le bhai puppi
Nice explanation
Thanku
Crystal clear 😊
Thanku
tnx tommorow is my exam
Welcome..
Best wishes for your exam
Amazing session....
Thanks
best.....
Thanku..
Ma'am If we apply these command(order wise, group wise)
Will it affect the original table.
No
I subscribed you channel mam I want to see your 1 lakh subscribers soon😊
me too...
Congrats
mam can you please tell the difference between group by and distinct
done!!
Mam can we use where condition in group by query
Having is used with group by
Ok mam thanku
Thanks ma'am!!
Welcome
Thankyou mam
Welcome
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
After order by...you have to write the name of the column, which you want to sort
@@SwatiChawlaofficial ty mam
Please write the syntax
How to map the count of students having backlogs at a particular age
👏👏👏👏👏👏👍👍👍
understood
Thanku🙏🏻👍🏻
Mam thank you so much
Most welcome 😊
👌👌👌👌👌👌
Thankyou mam for your help!!
Welcome
Thanks ma'am
Most welcome 😊
Mam is it necessary to write "order by, group by" in capital letters?
No.. it's a convention
HOW WE cn know total amount to pay monthly salaries of all emps in that department as sal is more than 9000
Thanks...
Welcome
Group by me
department me jitne log hai sbka name chahiye
Kse krenge mam ?
Ex . IT | 2 | Sonya , Rahul
Can i ask you a question of exam
Thanks a lot
TQ mam it clears all my doubts
Welcome
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 ?
select stream,count(*) from student1 group by stream having count(*)>=4 order by stream desc;
@@SwatiChawlaofficial Thanks mam 🤓, now no doubts left.. All clear
Maf is this all according to term2🙄🙄🙄🙄
Yes
Mam aap kon si kv ki ho
Mam what is the difference if we use count(*) and count() ???
Explained in this video..
ruclips.net/video/aHi1duh2dTk/видео.html
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?
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 🙂
@@SwatiChawlaofficial alright mam thank you, I had a doubt in this topic hence referred to this particular video. Thank you for clearing the doubt 😊
Welcome
🎈❤️
Mam thanku
Welcome
👍
Mam if in grop by we have to use any other name in the output instead of count(*) then what will be the query ??
Check out the explanation of scalar expression..
@@SwatiChawlaofficial mam can we also
use aliasing command for this ??
@@anshikagrover2322 e.g select sname, count(*) as "count" from student group by sname