w3resource

PostgreSQL Restricting and Sorting Data: Display the jobs/designations available in the employees table


9. Write a query to display the jobs/designations available in the employees table.

Sample Solution:

Code:

SELECT DISTINCT job_id  
FROM employees;

Sample table: employees


Output:

pg_exercises=# SELECT DISTINCT job_id
pg_exercises-# FROM employees;
   job_id
------------
 AC_ACCOUNT
 ST_MAN
 IT_PROG
 SA_MAN
 AD_PRES
 AC_MGR
 FI_MGR
 AD_ASST
 MK_MAN
 PU_CLERK
 HR_REP
 PR_REP
 FI_ACCOUNT
 SH_CLERK
 AD_VP
 SA_REP
 ST_CLERK
 MK_REP
 PU_MAN
(19 rows)

Relational Algebra Expression:

Relational Algebra Expression: Display the jobs/designations available in the employees table.

Relational Algebra Tree:

Relational Algebra Tree: Display the jobs/designations available in the employees table.

Practice Online


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

Previous: Write a query to display the last name of employees having 'e' as the third character.
Next: Write a query to display the name, including first_name, last_name, salary and 15% of salary as PF of all employees.

What is the difficulty level of this exercise?



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/postgresql-exercises/restricting-and-sorting-data/restricting-and-sorting-data-exercise-9.php