/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/valid_group_by_reference/mysql/query.sql
16 строк
413 B
Kyle Gray
test(endtoend): Split shema and queries (#2803)
04 окт 2023, 19:13
Не верифицирован
04 окт 2023, 19:13
5664224
Код
Авторство
О чём код?
-- name: ListAuthors :many SELECT id, name as full_name, bio FROM authors GROUP BY full_name; -- name: ListAuthorsIdenticalAlias :many SELECT id, name as name, bio FROM authors GROUP BY name; -- name: ListMetrics :many SELECT time_bucket('15 days', time) AS bucket, city_name, AVG(temp_c) FROM weather_metrics WHERE DATE_SUB(NOW(), INTERVAL 6 MONTH) GROUP BY bucket, city_name ORDER BY bucket DESC;