Code: Select all
select FirstLetter as DisplayVal, FirstLetter as ResultVal
from (select distinct substr(EMPLOYEES.LAST_NAME, 1, 1) as FirstLetter
from EMPLOYEES)
Code: Select all
select FirstLetter as DisplayVal, FirstLetter as ResultVal
from (select distinct substr(EMPLOYEES.LAST_NAME, 1, 1) as FirstLetter
from EMPLOYEES)
Code: Select all
SELECT DISTINCT SubQuery.FirstLetter AS DisplayVal,
SubQuery.FirstLetter AS ReturnVal
FROM EMPLOYEES,
(SELECT SUBSTR(EMPLOYEES.LAST_NAME, 1, 1) AS FirstLetter
FROM EMPLOYEES) SubQuery
ORDER BY DisplayVal