w3resource
SQL exercises

SQL exercises on employee Database: List the employees whose ID not starting with digit 68

SQL employee Database: Exercise-111 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

111. Write a query in SQL to list the employees whose ID not starting with digit 68.

Sample table: employees


Sample Solution:

SELECT emp_id,
       trim(to_char(emp_id,'99999'))
FROM employees
WHERE trim(to_char(emp_id,'99999')) NOT LIKE '68%';

Sample Output:

 emp_id | btrim
--------+-------
  66928 | 66928
  67832 | 67832
  65646 | 65646
  67858 | 67858
  69062 | 69062
  63679 | 63679
  64989 | 64989
  65271 | 65271
  66564 | 66564
  69000 | 69000
  69324 | 69324
(11 rows)

Practice Online


Sample Database: employee

employee database structure

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

Previous: Write a query in SQL to list the employees those who joined in 90's
Next: Write a query in SQL to list the employees whose names containing the letter 'A'.

What is the difficulty level of this exercise?