Hi,
I'm relatively new to SQL. I was wondering if there is something redundant in the query below - because I'm doing the same WHERE clause in the main query and the subquery.
SELECT category,
(CASE (SELECT COUNT(*) FROM systemvalues WHERE systemtypeid = 'xxxx' AND valuecode = 'yyyy')
WHEN 1 THEN alphavalue
WHEN 0 THEN numvalue
END) AS value
FROM systemvalues
WHERE systemtypeid = 'xxxx' AND valuecode = 'yyyy'
Thanks.