Select the last name of all employees, without duplicates.
| SELECT lastname FROM employees
| GROUP lastname BY lastname
10 rows 0 msec
| GROUP lastname BY lastname
10 rows 0 msec
| lastname |
|---|
| Doe |
| Efron |
| Foster |
| Goldsmith |
| Manikutty |
| ODonnell |
| Rogers |
| Smith |
| Stevens |
| Swamy |
GROUP eliminates duplicates. We do not have a distinct keyword.