Answer: The WHERE clause is used to filter rows from the result set based on specified conditions before grouping and aggregation. The HAVING clause is used to filter grouped rows from the result set ...
--SELECT City ,SUM(Salary)AS "TOTAL SALARY AS PER CITY" FROM EmployeeData GROUP BY City; --SELECT City ,SUM(Salary)AS "TOTAL SALARY AS PER CITY" FROM EmployeeData GROUP BY City HAVING City IN ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback