sql get the lowest value code example

Example: how to find lowest in sql

SELECT first_name, last_name, salary, job_id
FROM employees
WHERE salary = (SELECT MIN(salary) FROM employees);