2015-10-27 13:21 GMT+01:00 Rami Ojares :
>
>
> 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
That's so good I just wanted to see it by itself and repeat it to everyone!
:D
On 27/10/2015 4:28 PM, Lukas Eder wrote:
As far as I'm concerned, nothing beats a good glass of red wine whilst
reading the SQL standard documents in front of the fireplace. Somehow,
few people are with me on that ;
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 b
Hi there,
I'm looking for some experiences which tables with a huge amount of data
(5M+). To be a little bit more concrete what I'm interested in:
* How much data do you store (lines per table (amount of columns) , total
lines)
* Which hardware you use (CPU, RAM)
* How you run H2
* How do you q
2015-10-27 8:51 GMT+01:00 Rami Ojares :
> Thanks Lukas!
> It is always a pleasure to get these nuggets of important information from
> the standard that I don't want to read myself.
>
As far as I'm concerned, nothing beats a good glass of red wine whilst
reading the SQL standard documents in fron
Thanks Lukas!
It is always a pleasure to get these nuggets of important information
from the standard that I don't want to read myself.
Could you give me an example of what you can but in the having clause if
group by does not have any columns?
- Rami
On 26.10.2015 22:57, Lukas Eder wrote: