w3resource
SQLite exercises

SQLite Exercise: Get the maximum salary of an employee working as a Programmer

Write a query to get the maximum salary of an employee working as a Programmer.

Sample table: employees


SQLite Code:

SELECT MAX(salary) 
FROM employees 
WHERE job_id = 'IT_PROG';

Output:

MAX(salary)
-----------
9000

Sqlite Online Editor


Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous:Write a query to get the minimum salary from employees table.
Next: Write a query to get the average salary and number of employees working the department 90.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming