w3resource

SQLite Exercise: Get unique department ID from employee table

Write a query to get unique department ID from employee table.

Sample table : employees


SQLite Code :

SELECT DISTINCT department_id
FROM employees;

Output:

department_id
-------------
90
60
100
30
50
80

10
20
40
70
110

Relational Algebra Expression:

Relational Algebra Expression: Get unique department ID from employee table.

Relational Algebra Tree:

Relational Algebra Tree: Get unique department ID from employee table.

Practice SQLite Online


Model Database

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query to display the names (first_name, last_name) using alias name "First Name", "Last Name".
Next: Write a query to get all employee details from the employee table order by first name, descending.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook