I tried but no way for DISTINCT
So I listen my instinct!
Then a way comes out SELECT FROM
WHERE do bring IN from WHERE without DISTINCT!
No DISTINCT, no JOIN, I hear the call,
A pure SELECT FROM—that’s all!
A WHERE within a WHERE so keen,
IN the answer, smooth and clean!
Nice warm-up before tough kata's! Thanks!
This dojo makes me a poet!
Here is my poem for this exercise:
Here is my poem for this exercise:
-- I thought I could round with ROUND(),
-- I even thought I could cast something with CAST(),
-- but only trunc() helped me before I truncated, while I was progressing!
-- The decimals danced away, ROUND couldn’t stay,
-- But trunc() stepped in, leading the way!