Difference Between Where and Having Clause | Explained with examples | SQL Tutorial Part 16 скачать в хорошем качестве

Difference Between Where and Having Clause | Explained with examples | SQL Tutorial Part 16

Hello Everyone, This is the 16th part of the SQL Tutorial for Beginners. You can refer to the playlist 'SQL Tutorial' for all related videos. In this video, we are going to discuss: 1.Difference between Where and Having Clause 2.Explained with examples in detail -------------------------------- SQL Query ----------------------------------------------- select * from dbo.sales --Example 1: Find out total sales per dept , but only consider rows where sale amt 1000 select department, SUM(sale_amount) as total_sale from dbo.sales where sale_amount 1000 Group by department --Example 2: Find out total sale per dept 2000 select department,SUM(sale_amount) AS total_sale from dbo.sales Group by department having SUM(sale_amount) 2000 --Example 3: Find employees who made more than one sale but only consider sale above 800 Select employee_name,count(*) as number_of_sales from dbo.sales where sale_amount 800 group by employee_name having count(*) 1 select * from dbo.sales