PostgreSQL Basic SELECT Statement: Get the unique number of designations available in the company

10. Write a query to get the unique number of designations available in the employees table.

Sample Solution:

Code:

SELECT COUNT(DISTINCT job_id) 
FROM employees;

Sample table: employees

Output:

pg_exercises=# SELECT COUNT(DISTINCT job_id)
pg_exercises-# FROM employees;
 count
-------
    19
(1 row)

Practice Online

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to get the number of employees working with the company.
Next: Write a query to get all the first name from the employees table in upper case.