w3resource

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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.