SQL "difference between" interview questions (part 1)

Very helpful.. thank you..✨

Correct syntax for WHERE AND HAVING scenario is
SELECT MAX(sal) FROM emp WHERE emp_id > 100;

The query using the HAVING clause is not correct in this context.

WHERE Clause:

The WHERE clause is used to filter rows before they are grouped or aggregated.
It operates on individual row data and filters rows based on column values.
Example: SELECT * FROM orders WHERE order_date > '2023-01-01';

HAVING Clause:
The HAVING clause is used to filter the results of aggregate functions after they have been applied.
It is used in combination with the GROUP BY clause to filter the result set based on aggregate functions like SUM, AVG, MAX, MIN, etc.
It operates on groups of rows created by the GROUP BY clause.
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

When to use IN and exists this I learned from your video

Nice tutorial and clear voice to understand.

Love these videos. Great job!

Thank you this has helped me a lot

Thankyou..!!

Great👍

I want this one
A B C
1 2 3
4 5 6
7 8 9
I want maximum value? Please tell me

Thanks for this video ...

Aggregate function
It is used to multiple rows of single column

❤️❤️❤️ thank you❤️❤️❤️

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.

Thank you

Nice way of explaining 👍

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

This is nice!

What is count of customers buying perticular product in Technology and Furniture category
-- in year 2011 and 2012.

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.

I know you voted!

Simply explained, thank you :)

Very nice explanation

Tq

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

Thanks Sadia this video very helpful for us , can u make postman api interview questions like SQL interview videos

thanku :)

Pls can you forward that Written book to my mail id..?

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

we can use where clause in aggrigate function then what is nessary of having clause can u explaine me

Good explanation

Nice

Madam can u explain in plsql, index, view in asking interviews

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

Nice mam 👍 thanks 😊

Your notes are so well define easy to understand

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

Excellent explanation

Your really great

Put in tamil

Provide pdf notes

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

Hi warm greetings good morning

Thank you for sharing the valuable information. Could you please share some more complex queries to resolve If you can make some more thought queries which is well explained and easy to understand. I lost my last job I am in look out for a job

Thanks - was so helpful

very nice voice, explained in good way

Awesome voice and good explanation 😍

Thank you sadia

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

Thanks for the making videos! Its very very helpful