Q:

From the following table, write a SQL query to find unique last name of all employees. Return emp_lname

0

From the following table, write a SQL query to find unique last name of all employees. Return emp_lname.

 EMP_IDNO EMP_FNAME       EMP_LNAME         EMP_DEPT
--------- --------------- --------------- ----------
   127323 Michale         Robbin                  57
   526689 Carlos          Snares                  63
   843795 Enric           Dosio                   57
   328717 Jhon            Snares                  63
   444527 Joseph          Dosni                   47
   659831 Zanifer         Emily                   47
   847674 Kuleswar        Sitaraman               57
   748681 Henrey          Gabriel                 47
   555935 Alex            Manuel                  57
   539569 George          Mardy                   27
   733843 Mario           Saule                   63
   631548 Alan            Snappy                  27
   839139 Maria           Foster                  57

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT DISTINCT emp_lname
FROM emp_details;

Output of the Query:

emp_lname
Saule
Robbin
Sitaraman
Mardy
Foster
Emily
Manuel
Dosio
Gabriel
Snappy
Snares
Dosni

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions


need a help?


find thousands of online teachers now