Best thing about your videos is You take very less time to cover many things and yet explaining it so beautifully.. Thanks for spreading the knowledge.. 👍🏻
You can still use WHERE clause aggregated functions. Select max(column) from table where Meaning: select max out of a column value from a table with a filtered records based on a condition.
Great job sis.. kudos!! Small correction @ 3:33 ---- 'Where' can be used while aggregating rows (Where and Group by works) 'Where' will filter at Row level 'Having' will filter at 'Group by' level No intention of pointing out mistakes here.. your channel is gaining popularity, and many are learning from this channel, great job!!. On the same lines - my two cents .. if that helps your viewers!! Oh, I haven't seen before - couple of others also mentioned about this correction.. great!! Good job!! (wouldn't have posted this if i have seen that earlier) Good job everyone!! Happy learning!!
Sir I need to add few more points and let me know if I am wrong. If where clause is being used after the 'group by' statement this wouldn't work out. If we want SQL to use group by with where, 'where clause' should be used before Group by statement which actually filters the data from reference table first then grouping the data. Since, we are not using any aggregate function to group our data hence this group by also acts like order by. Disagree if I am wrong
Hi, please watch the below linked video to understand the difference between WHERE and HAVING even better. ua-cam.com/video/ggBXefD4UT8/v-deo.html ✨Link to my SQL e-book: imojo.in/rkajq9 ✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
I need help , the other video you made explaining how you to find the second highest salary with MAX . It was Select MAX(salary) from employee Where salary < ( select Max (Salary) from employee ). Thats using an aggregated function with "where "which you just said otherwise
I've been looking for something like this from a long time.I've not seen any video where SQL is explained in such a simple and easy way. Thanks a lot for this.
We can use where clause and having too because we can filter non aggregated value and having count(emp_id)>=1 . Instead of using having emp_id>105 u shld have use where emp_id>105
I have started watching your videos recently, believe me you are amazing the way explained just nailed it.Impressive work keep it up last but not least thank you.
Having is the only solution giving you the option to filter on the results of the aggregate function. Where can still be used on the other fields of the dataset before the aggregate functions are processed.
Great job But one small correction at 3:57 where can be used also with group by but before group by statement and having can be used on aggregate function as you said Like: SELECT MAX(Sal) FROM Employee GROUP BY EmpId HAVING MAX(Sal) > 1000;
Hi, The best thing is that All of your videos are clearly explained in a short period of Time and it covers many things. I Really appreciate ur effort and please keep on continuing it🙏🙏 Thanks you so much
thank u mam such simple explaination about union i never understand my whole enginnering .....keep provide us such .. this type of information... thank u so mmuch ......🤗🤗🤗🤗🤗🤗🤗
It's a great post @Crack Concepts (Sadia) , no matter how many years of experience we have ,it's always a good revision for any one # WHERE can be used with SELECT,INSERT,UPDATE statement # HAVING can only be used with SELECT statement
Though I am using SQL(DBA) for 3 years, never focused much on the difference between UNION and UNION ALL. Today I gave an interview for one of the Big4 and I couldn't answer the difference between UNION vs UNION ALL. Finally landed here to understand the diff.
...... hopefully you don't use it because that's a massive difference LOL. You would ruin a dataset not using Union all. Union all is used 99.9% of the time. There would be no point to be removing duplicate rows.
I like the way you explain; your voice is clear and explanations are concise. I would have like to see a query written per each example/case to illustrate each use per clause. First time on your channel and looking forward to more of your SQL videos. BTY, I’m new to SQL, hoping to learn it fast, mastering this skill type of structure language.
You do great efforts, aggregating those neatly written paper docs. It would require lot of hard work. Please give a try to ms word where changes or corrections also would be easier for you. And Mysql database with ms workbench which is opensource, would save your time and your efforts a lot. Great work, you would come up with flying colours. Best of luck...
@@Rajahmundry-timepass I ran all queries and they are working fine. If you can't run simple queries, stop blaming the teacher. You piece of shit. Stop spreading negativity for her. She is doing a great job. But stupid people like you can't understand anything.
The concept explained is correct but the example given is wrong for where Vs having. WHERE doesn't work with aggregate functions when they are mentioned directly in WHERE clause. For ex:- SELECT count(empid) from employee where salary>avg(salary). This would give an error. But your query where you are using aggregate in select but not in where it would work just fine. Hope you understand it ✌️
Best thing about your videos is You take very less time to cover many things and yet explaining it so beautifully.. Thanks for spreading the knowledge.. 👍🏻
You can still use WHERE clause aggregated functions.
Select max(column) from table where
Meaning: select max out of a column value from a table with a filtered records based on a condition.
Yes.
And we can't use having without group by
Yes
ua-cam.com/video/QTaiF8N6i3Y/v-deo.html🙏🏻🙏🏻
This UA-camr has no idea what she is talking about man....
ua-cam.com/video/p0gL1pAhGZE/v-deo.html
Great job sis.. kudos!!
Small correction @ 3:33 ---- 'Where' can be used while aggregating rows (Where and Group by works)
'Where' will filter at Row level
'Having' will filter at 'Group by' level
No intention of pointing out mistakes here.. your channel is gaining popularity, and many are learning from this channel, great job!!. On the same lines - my two cents .. if that helps your viewers!!
Oh, I haven't seen before - couple of others also mentioned about this correction.. great!! Good job!!
(wouldn't have posted this if i have seen that earlier)
Good job everyone!! Happy learning!!
Thank you 😊
I really like the way you explained and it is useful for me...
Sir I need to add few more points and let me know if I am wrong. If where clause is being used after the 'group by' statement this wouldn't work out. If we want SQL to use group by with where, 'where clause' should be used before Group by statement which actually filters the data from reference table first then grouping the data. Since, we are not using any aggregate function to group our data hence this group by also acts like order by. Disagree if I am wrong
ua-cam.com/video/p0gL1pAhGZE/v-deo.html
Thanks for this. I could have got wrong understanding now about using HAVING clause.
Hi, please watch the below linked video to understand the difference between WHERE and HAVING even better.
ua-cam.com/video/ggBXefD4UT8/v-deo.html
✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
. mn
how to contact u mam
I need help , the other video you made explaining how you to find the second highest salary with MAX . It was
Select MAX(salary) from employee
Where salary < ( select Max
(Salary) from employee ). Thats using an aggregated function with "where "which you just said otherwise
Hii I want to
Take course from you how can I contact you pls
Thanku mam
I became fan of your voice nd thanks for the most common interview question explained in great manner👍👍👍🙏
🤣🤣🤣🤣🤤🤤
Men is always men
(meanwhile in the background I heard)
Pyar ki raah mein chalnaa seekh....
Creep spotted 😂😂😂
@@Bdlover-24 🙏
The way she says sorry sorry ❤️.. great tutorial ..am following every video.. simple and to the point ..
I've been looking for something like this from a long time.I've not seen any video where SQL is explained in such a simple and easy way. Thanks a lot for this.
We can use where clause and having too because we can filter non aggregated value and having count(emp_id)>=1 . Instead of using having emp_id>105 u shld have use where emp_id>105
Correct. Made a mistake there. Thanks for correcting! :)
@@crackconcepts No worries and thank you for educating us 😀😊
Amazing video series on SQL. Honestly this has been my ONLY goto channel whenever I feel I need to brush up my SQL coding skills.
I am thankful that such a clear and knowledgeful information shared for all
May God bless you for the helping and sharing
thank you
I have started watching your videos recently, believe me you are amazing the way explained just nailed it.Impressive work keep it up last but not least thank you.
Thank you so much!!
Having is the only solution giving you the option to filter on the results of the aggregate function. Where can still be used on the other fields of the dataset before the aggregate functions are processed.
I gained confidence from your teaching. Kudos
Thank you, sister, the way you teach is wonderful, stay blessed and happy forever. as a beginner, I admire your effort.
When we use max() function still we can use the where clause it works.
Yes
Yes but it should be before having clause
Yes even I wondered when she said that .. I do it daily...
What she said is exactly what I found on w3schools.
We can use it on to find maximum values in the database
Whatt a Amazing voice !!!😍😍🥰♥️
& Explanation is also good 💜
1. Aggregate
2. Duplicate
3. Scan and Boolean evaluation
4. Position
5. Performance
6. Columns and Rows
I think this video was done at election time. This video helped me now. Nyc1
Your voice is really sweet Mam.. A very good and simple way of explaining 👍
Great job
But one small correction at 3:57 where can be used also with group by but before group by statement and having can be used on aggregate function as you said
Like:
SELECT MAX(Sal) FROM Employee
GROUP BY EmpId
HAVING MAX(Sal) > 1000;
Speak more loudly 🙃🙃
Aggregate function
It is used to multiple rows of single column
Mam your voice is so sweet and the way of your teaching is also good
Hi, The best thing is that All of your videos are clearly explained in a short period of Time and it covers many things. I Really appreciate ur effort and please keep on continuing it🙏🙏 Thanks you so much
thank u mam such simple explaination about union i never understand my whole enginnering .....keep provide us such .. this type of information... thank u so mmuch ......🤗🤗🤗🤗🤗🤗🤗
This and the second part is sooooo Awesome. You Rock. Blessings from United States. :)
what a voice WOW
Nice. You are explaining things clear. Like inner query and outer query.
Ur way of explaining concepts is simple and cool to understand soon....
Tq for sharing videos..
clear, simple and easy way of explanation , Thank you !
Execution order of clauses---
1.From
2.Where
3.Group By
4.Having
5.Order by
6.Select.
Mam the way of explanation is super thanks for given valuable classes
Thank you..Concepts clearly explained in short time..GOD bless you
A good and knowledgeable video, thank you sister for sharing with us.
It's a great post @Crack Concepts (Sadia) , no matter how many years of experience we have ,it's always a good revision for any one
# WHERE
can be used with SELECT,INSERT,UPDATE statement
# HAVING
can only be used with SELECT statement
We can get the aggregate by using where as well
mam, please note the correction that, where can be used in your explanation for id, having is only used for aggregated filters.
THANK YOU SO MUCH!!!! Cleared all the doubts in a single go!
we can use where instead of having , we use having when we place the group by clause
Short,simple and clear explanation.. Really liked it so much:)
Thank you so much!
Very very nice and simple methods with examples 😄😄😄 thank u for videos
Nice tutorial and clear voice to understand.
That multiippllee rows❣️2:10
2:04
Nice and clear explanation, thank you very much from south yemen.
God bless... very straight to the point... Perfect... Kudos to your work
Though I am using SQL(DBA) for 3 years, never focused much on the difference between UNION and UNION ALL. Today I gave an interview for one of the Big4 and I couldn't answer the difference between UNION vs UNION ALL. Finally landed here to understand the diff.
...... hopefully you don't use it because that's a massive difference LOL. You would ruin a dataset not using Union all. Union all is used 99.9% of the time. There would be no point to be removing duplicate rows.
I think u just time pass if u don't know the difference sorry but it's true
When to use IN and exists this I learned from your video
Best sql channel ...thanks mam for this series and all effort u have put in
SELECT count(country) from customers where customerid>5;
it is working
Great tutorials. Thank You very much. looking forward for more videos from you.
Please explain the difference between partition by and group by
Thank you.. Your way of explaining is sweet.
amazing what a voice and you are explanation also awesome keep going
Good job mam👍👍
Please upload more videos regarding plsql with examples as many as u can .
Your explanation is tremendous ...
very helpful for the interview preparation
Thanks for sharing very well explained
Straight concept clear voice ....cool
Your notes are so well define easy to understand
It was a great video of explaining such a complicated concepts 👍.
You have a wonderful soft voice ..
very well explained . I watched just one video & subscribed .
I like the way you explain; your voice is clear and explanations are concise. I would have like to see a query written per each example/case to illustrate each use per clause.
First time on your channel and looking forward to more of your SQL videos. BTY, I’m new to SQL, hoping to learn it fast, mastering this skill type of structure language.
Thank you so much Ma'am for your detailed information. This helped me to brushed up
This is nice!
We can use where when using group by also.
To the point ,
helped me.
Thank you 😀
You are explaining so good and your voice also amazing
Great work mam
Thank you this has helped me a lot
very nice voice, explained in good way
Thanks for the making videos! Its very very helpful
You do great efforts, aggregating those neatly written paper docs. It would require lot of hard work.
Please give a try to ms word where changes or corrections also would be easier for you.
And Mysql database with ms workbench which is opensource, would save your time and your efforts a lot.
Great work, you would come up with flying colours. Best of luck...
Highly appreciate your work. Thanks
@@Rajahmundry-timepass I ran all queries and they are working fine. If you can't run simple queries, stop blaming the teacher. You piece of shit.
Stop spreading negativity for her. She is doing a great job. But stupid people like you can't understand anything.
Please make more difference between in Location and Add...
You are doing well, Great job but your voice was awesome than topic.
simping kahi aur jaake kar xD
Volume of teaching can be increased to hear well and understand.Thank you
Voice is pleasant
Padai pe dyaan dede
@@hrishikeshkonderu1638 voice is distracting
Very nicely explained! and your voice is soooo sweet!
Keep it up👍
Simply explained, thank you :)
Good explanation
Thank you ma'am. Cause of you i was able to crack the interview for my dream job ❤
I’m so happy for you. Congratulations!
@@crackconcepts thank you. Andbi am very much greatful to your videos. I learned more from your course then in 6 mths of my college
also add one more component --group by and partition by
Thanks for this video ...
Great explanation, thank you, dear
Great job sister . Best tutorials I have ever seen . Keep it up
The concept explained is correct but the example given is wrong for where Vs having. WHERE doesn't work with aggregate functions when they are mentioned directly in WHERE clause. For ex:- SELECT count(empid) from employee where salary>avg(salary). This would give an error. But your query where you are using aggregate in select but not in where it would work just fine. Hope you understand it ✌️
Nice way of explaining 👍
excellent
select max(sal) from emp
having empno>7900
Will given an error ORA-00979: not a Group BY expression
having keyword cannot be used without group by
Please use where in place of having. Having is used with agreegate condition and with group by is also require. In video everything is not correct..
Very nice explanation
achha pdhati ho, keep it .
You are doing great job sister with husky voice
Proper explanation with great presentation 😊
Thank you for the video!
Nicely explained. Mam
NIcely explained, Thank you
Excellent explanation
Very mild n cute voice ❤️
soothing voice and excellent explanation !! too good. Can we get these notes ?
Nice mam 👍 thanks 😊
One suggestion please add the final output also..it will really help many
Awesome voice and good explanation 😍
Love these videos. Great job!