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?



Share this Tutorial / Exercise on : Facebook and Twitter