Group by | having and order by clause in Sql| what is difference between having and where in sql.
Group by in sql and having clause in sql.
what is difference between having and where clause.
Order by clause in SQL.
Order by default sorting is Ascending order.
SELECT MAX(E1.Salary) AS SALARY,D1.DepName FROM Department AS D1
INNER JOIN Emp AS E1 ON
E1.EmpId=D1.EmpId
GROUP BY DepName
HAVING MAX(Salary) =150
-------------------------------------------------------------------------------
SELECT E1.Salary AS SALARY,E1.EmpName,D1.DepName FROM Department AS D1
INNER JOIN Emp AS E1 ON
E1.EmpId=D1.EmpI
