Having Clause in SQL | SQL Step by Step Tutorial Part 15 скачать в хорошем качестве

Having Clause in SQL | SQL Step by Step Tutorial Part 15

Hello Everyone, This is the 15th 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.Having Clause 2.Explained with examples -------------------------------- SQL Query ----------------------------------------------- --Having Clause select * from dbo.sales --Example 1: Total sales per dept Select department,SUM(sale_amount) as total_sales from dbo.sales Group by department --Example 1: Total sales per dept where total sale amount should be greater than 2000 Select department,SUM(sale_amount) as total_sales from dbo.sales Group by department having SUM(sale_amount) 2000 --Example 3:No of sales made by employees select employee_name,count(*) as total_sales from dbo.sales Group by employee_name having count(*) 1;