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:

-- 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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.