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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.