SQL "difference between" interview questions (part 1)

Рет қаралды 613,021

Күн бұрын

In this video, we'll understand some important sql interview questions. These questions are often asked in interview and should be known by anyone who wants to master SQL.
Following are the questions which will be covered in this video:
1. Difference between where and having?
2. Difference between union and union all?
3. Difference between in and exists?
This is part 1 of this video.
Part 2 will be released tomorrow.
In part 2, the following questions will be covered:
4. Difference between group by and order by?
5. Difference between join and sub query?
6. Difference between join and union?
✨Work related mails can be sent on:
work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadia1702

Пікірлер: 264

@madhurpalsokar7790 4 жыл бұрын

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.. 👍🏻

@kunalgandhe4551 Жыл бұрын

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.

@radhemohannaamhai 3 жыл бұрын

The way she says sorry sorry ❤️.. great tutorial ..am following every video.. simple and to the point ..

@dipakk123 3 жыл бұрын

I am thankful that such a clear and knowledgeful information shared for all May God bless you for the helping and sharing thank you

@charlesmathews6184 3 жыл бұрын

I gained confidence from your teaching. Kudos

@sartz444 3 жыл бұрын

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

@anvi015 7 ай бұрын

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.

@rohanmali6583 3 жыл бұрын

This and the second part is sooooo Awesome. You Rock. Blessings from United States. :)

@nagoredeen 3 жыл бұрын

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.

@ruturajjadhav8905 2 жыл бұрын

Yes. And we can't use having without group by

@nishiagarwal9869 2 жыл бұрын

Yes

@rameshmalhotra9525 2 жыл бұрын

kzfaq.info/get/bejne/h7qRnKlps5zNY40.html🙏🏻🙏🏻

@chilly2171 2 жыл бұрын

This KZfaqr has no idea what she is talking about man....

@rameshmalhotra9525 2 жыл бұрын

kzfaq.info/get/bejne/ppaXf5Shps6rink.html

@suhailahamed7514 2 жыл бұрын

Thank you, sister, the way you teach is wonderful, stay blessed and happy forever. as a beginner, I admire your effort.

@chandrassqlbi4343 4 жыл бұрын

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

@crackconcepts 3 жыл бұрын

Thank you 😊

@antonyjayaraj95 3 жыл бұрын

I really like the way you explained and it is useful for me...

@praveengupta2369 3 жыл бұрын

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

@rameshmalhotra9525 2 жыл бұрын

kzfaq.info/get/bejne/ppaXf5Shps6rink.html

@vaishalidharmik2038 Жыл бұрын

Thanks for this. I could have got wrong understanding now about using HAVING clause.

@tekieogubagabir43 4 жыл бұрын

clear, simple and easy way of explanation , Thank you !

@gauravnegi4312 3 жыл бұрын

THANK YOU SO MUCH!!!! Cleared all the doubts in a single go!

@vivamedia5958 4 жыл бұрын

Great tutorials. Thank You very much. looking forward for more videos from you.

@sohailkat8867 4 жыл бұрын

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.

@crackconcepts 4 жыл бұрын

Thank you so much!!

@anunutan9220 3 жыл бұрын

Ur way of explaining concepts is simple and cool to understand soon.... Tq for sharing videos..

@vS-mn9id 3 жыл бұрын

God bless... very straight to the point... Perfect... Kudos to your work

@ajajjamadar 3 жыл бұрын

Great job sister . Best tutorials I have ever seen . Keep it up

@shahzan525 3 жыл бұрын

Most usefull ..... Great work 👍

@shreyjainhere 3 жыл бұрын

Your voice is really sweet Mam.. A very good and simple way of explaining 👍

@kumarakrish3976 3 жыл бұрын

Proper explanation with great presentation 😊

@archanapbhat5232 2 жыл бұрын

Thank you..Concepts clearly explained in short time..GOD bless you

@bootexcel5122 Жыл бұрын

Nice. You are explaining things clear. Like inner query and outer query.

@hadireg 2 жыл бұрын

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.

@buildtolearn Жыл бұрын

Love these videos. Great job!

@virendrabhati6685 2 жыл бұрын

It was a great video of explaining such a complicated concepts 👍.

@Faisal1504 3 жыл бұрын

Thanks for sharing very well explained

@tariqzaman2077 2 жыл бұрын

A good and knowledgeable video, thank you sister for sharing with us.

@manognakarimi 3 жыл бұрын

To the point , helped me. Thank you 😀

@gauravghosh8002 3 жыл бұрын

Thank you so much Ma'am for your detailed information. This helped me to brushed up

@prashantp9029 2 жыл бұрын

Good job mam👍👍 Please upload more videos regarding plsql with examples as many as u can . Your explanation is tremendous ...

@anujlovetube 3 жыл бұрын

Best sql channel ...thanks mam for this series and all effort u have put in

@SameerShaikh-ty5zt 2 жыл бұрын

Thank you.. Your way of explaining is sweet.

@JinkaJayakrishna 3 ай бұрын

Mam the way of explanation is super thanks for given valuable classes

@vijaypanchal7344 Жыл бұрын

Nice tutorial and clear voice to understand.

@331sairam 3 жыл бұрын

Straight concept clear voice ....cool

@sutharshansrikumar3001 2 жыл бұрын

Very nice explanation

@narenderuggera1972 3 жыл бұрын

I became fan of your voice nd thanks for the most common interview question explained in great manner👍👍👍🙏

@manikandan-hz8yd 2 жыл бұрын

🤣🤣🤣🤣🤤🤤

@Bdlover-24 2 жыл бұрын

Men is always men

@leisuretime8023 2 жыл бұрын

(meanwhile in the background I heard) Pyar ki raah mein chalnaa seekh....

@Mohammed-up8lg 2 жыл бұрын

Creep spotted 😂😂😂

@narenderuggera1972 2 жыл бұрын

@@Bdlover-24 🙏

@yasmeenhasan9925 2 жыл бұрын

Thanks for the making videos! Its very very helpful

@Jooockerx 2 жыл бұрын

Nice and clear explanation, thank you very much from south yemen.

@crackconcepts 3 жыл бұрын

Hi, please watch the below linked video to understand the difference between WHERE and HAVING even better. kzfaq.info/get/bejne/nc1yi8iXqZq5hGw.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)

@bhuvananithu1466 2 жыл бұрын

. mn

@ramireddygopalreddy4316 2 жыл бұрын

how to contact u mam

@afuhcyrilcheuck5032 2 жыл бұрын

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

@balanagadurgasrilakshmi8562 2 жыл бұрын

Hii I want to Take course from you how can I contact you pls

@sumityerme3811 2 жыл бұрын

Thanku mam

@Rohitkumar-vq1yk Жыл бұрын

Thank you this has helped me a lot

@vminkook_lover782 3 жыл бұрын

Whatt a Amazing voice !!!😍😍🥰♥️ & Explanation is also good 💜

@zaidzeee 3 жыл бұрын

Amazing work keep it up

@bollywoodupdates1706 2 жыл бұрын

Thank you for the video!

@honestcomments8053 3 жыл бұрын

Excellent video!

@gauravrawat5521 2 жыл бұрын

Your notes are so well define easy to understand

@Kamil0289 2 жыл бұрын

Simply explained, thank you :)

@anilb5557 2 жыл бұрын

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 ......🤗🤗🤗🤗🤗🤗🤗

@ajinkya820 3 жыл бұрын

You have a wonderful soft voice ..

@bhushandatey5792 2 жыл бұрын

very well explained . I watched just one video & subscribed .

@itdp.warangal 2 жыл бұрын

I think this video was done at election time. This video helped me now. Nyc1

@RahulGupta-fk4cz 5 ай бұрын

Mam your voice is so sweet and the way of your teaching is also good

@yokeshviswanathan1220 2 жыл бұрын

amazing what a voice and you are explanation also awesome keep going

@sonukumar-pr2nc 5 жыл бұрын

achha pdhati ho, keep it .

@shreyasjadhav7323 Жыл бұрын

Thanks for this video ...

@nelikantinagaraj4866 2 жыл бұрын

Very very nice and simple methods with examples 😄😄😄 thank u for videos

@jf1341 3 жыл бұрын

Very well presented 🙏 👌👌👏👏

@mukulverma9966 3 жыл бұрын

You are explaining so good and your voice also amazing Great work mam

@user-pe9wc7ig2i 3 жыл бұрын

Great explanation, thank you, dear

@sivareddyalavala4425 2 жыл бұрын

Good explanation

@varunwadekar7 5 ай бұрын

very helpful for the interview preparation

@deepakpandey9406 3 жыл бұрын

1. Aggregate 2. Duplicate 3. Scan and Boolean evaluation 4. Position 5. Performance 6. Columns and Rows

@SureshKumar-ug4ep 2 жыл бұрын

Very nicely explained! and your voice is soooo sweet! Keep it up👍

@CodeWithFiroj 2 жыл бұрын

Good one.

@poojatiwari6290 Жыл бұрын

Nice way of explaining 👍

@ashutoshgaur8105 2 жыл бұрын

very nice voice, explained in good way

@manikantatatvamasi7804 3 жыл бұрын

NIcely explained, Thank you

@samirdeshmukh9886 8 ай бұрын

Very helpful.. thank you..✨

@harshsugandhi07 3 жыл бұрын

Nicely explained 🔥

@vipin2872 2 жыл бұрын

Nicely explained. Mam

@letsdoit6438 2 жыл бұрын

Excellent explanation

@netwkeng7101 3 жыл бұрын

You are doing great job sister with husky voice

@amanbhargava2702 2 жыл бұрын

Thank you sadia

@chaithanyagosangi8950 3 жыл бұрын

mam, please note the correction that, where can be used in your explanation for id, having is only used for aggregated filters.

@hibasyed7646 3 жыл бұрын

Helpful 👍

@ashokchandra4911 2 жыл бұрын

Nice tutorial didi

@AshokKumar-fm7xb 3 жыл бұрын

Good job 🙏

@tanushreenagar3116 2 жыл бұрын

Nice mam 👍 thanks 😊

@jvinaykumar3274 2 жыл бұрын

Awesome voice and good explanation 😍

@leadprogrammer 3 жыл бұрын

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

@NikitaSharma-bs4gg 2 жыл бұрын

Thanks - was so helpful

@harshalpatil2009 3 жыл бұрын

Informative

@parthasarathyraja8917 3 жыл бұрын

Volume of teaching can be increased to hear well and understand.Thank you

@unknowns9500 2 жыл бұрын

we can use where instead of having , we use having when we place the group by clause

@kailastapase33 2 жыл бұрын

Your really great

@nishanthgaddam8426 4 жыл бұрын

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

@crackconcepts 4 жыл бұрын

Correct. Made a mistake there. Thanks for correcting! :)

@nishanthgaddam8426 4 жыл бұрын

@@crackconcepts No worries and thank you for educating us 😀😊

@Lalit_Sharma_20 2 жыл бұрын

soothing voice and excellent explanation !! too good. Can we get these notes ?

@snuffshot9287 6 ай бұрын

Thank you 🙏

@malhotrapawan9001 Жыл бұрын

Great👍

@A4Abhinav 3 жыл бұрын

Awesome video

@mushiburrahamanmallick3372 2 жыл бұрын

excellent

@piyushkapil9598 4 жыл бұрын

Thanku so much please make more videos

@SanjaySharma-rl3xu 2 жыл бұрын

This is nice!

@SanjaySharma-rl3xu 2 жыл бұрын

We can use where when using group by also.

@ShubhamKumar-fz3oc 3 жыл бұрын

One suggestion please add the final output also..it will really help many

@pankajsharmadelhi93 3 жыл бұрын

Please make one video on pivoting the data from rows to columns too

@dcrocks3614 4 жыл бұрын

I have tried having clause with Max function but it's not allowing me to use : Column 'salaries.emp_no' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.