Sha256: 7e9bffccc1fb9267d2fea701608de8c3f8f2b7290fdff6033f2e298c599414a3
Contents?: true
Size: 360 Bytes
Versions: 5
Compression:
Stored size: 360 Bytes
Contents
// vim: ft=javascript
// For each brewery that offers more than 30 beers, the following group-by or
// aggregate query reports the number of beers that it offers. With a
// hash-based aggregation hint.
{
"statement": "SELECT br.brewery_id, COUNT(*) AS num_beers FROM beers br /*+ hash */ GROUP BY br.brewery_id HAVING COUNT(*) > 30 ORDER BY COUNT(*) DESC"
}
Version data entries
5 entries across 5 versions & 2 rubygems