Page 1 of 1
Visual query designer functionality
Posted: Sun 17 Apr 2016 13:19
by Mowelac
Is it possible to create such a query using visual query designer?
Code: Select all
select FirstLetter as DisplayVal, FirstLetter as ResultVal
from (select distinct substr(EMPLOYEES.LAST_NAME, 1, 1) as FirstLetter
from EMPLOYEES)
Re: Visual query designer functionality
Posted: Sun 17 Apr 2016 19:29
by Mowelac
It can simply be done with subquery, Query → Create Subquery
Re: Visual query designer functionality
Posted: Mon 18 Apr 2016 09:11
by alexa
Re: Visual query designer functionality
Posted: Mon 18 Apr 2016 18:44
by Mowelac
Thank you, alexa, as I mentioned, I have managed to make required query using subquery. Following SQL, constructed in visual builder, does what I want:
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
Re: Visual query designer functionality
Posted: Tue 19 Apr 2016 07:38
by alexa
Thank you for updating us on this issue. Please let us know if any question arise.