Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to find lowest salary by departments ?

SELECT 
    MIN(salary)
FROM
    employees
GROUP BY department_id
ORDER BY MIN(salary) DESC;
Code language: SQL (Structured Query Language) (sql)
Source by www.sqltutorial.org #
 
PREVIOUS NEXT
Tagged: #find #lowest #salary #departments
ADD COMMENT
Topic
Name
7+1 =