SELECT
string_agg(title, ', ')
FROM
film
WHERE
title LIKE 'AN%'
HAVING
count(*) > 5
"Return a concatenation of all the films starting with "AN", *IF*
there are at least 5 such films."
Where in the statement does it say that the rows should be grouped by
their title column?
To be more specific what does GROUP BY() mean?
I would understand the statement better if it would have GROUP BY(title).
- Rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
