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:

-- Counting the number of distinct job IDs in the employees table
SELECT COUNT(DISTINCT job_id) 
-- Selecting data from the employees table
FROM employees;

Explanation:

• This SQL code counts the number of distinct job IDs present in the "employees" table.
• The COUNT(DISTINCT job_id) function is used to count the number of unique job IDs in the table.
• The result set will contain a single column with the count of distinct job IDs in the employees table.

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.