0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
42 lines
861 B
SQL
42 lines
861 B
SQL
-- name: GetAvg :one
|
|
SELECT avg(int_val) FROM test;
|
|
|
|
-- name: GetCount :one
|
|
SELECT count(*) FROM test;
|
|
|
|
-- name: GetCountId :one
|
|
SELECT count(id) FROM test;
|
|
|
|
-- name: GetGroupConcatInt :one
|
|
SELECT group_concat(int_val) FROM test;
|
|
|
|
-- name: GetGroupConcatInt2 :one
|
|
SELECT group_concat(1, ':') FROM test;
|
|
|
|
-- name: GetGroupConcatText :one
|
|
SELECT group_concat(text_val) FROM test;
|
|
|
|
-- name: GetGroupConcatText2 :one
|
|
SELECT group_concat(text_val, ':') FROM test;
|
|
|
|
-- name: GetMaxInt :one
|
|
SELECT max(int_val) FROM test;
|
|
|
|
-- name: GetMaxText :one
|
|
SELECT max(text_val) FROM test;
|
|
|
|
-- name: GetMinInt :one
|
|
SELECT min(int_val) FROM test;
|
|
|
|
-- name: GetMinText :one
|
|
SELECT min(text_val) FROM test;
|
|
|
|
-- name: GetSumInt :one
|
|
SELECT sum(int_val) FROM test;
|
|
|
|
-- name: GetSumText :one
|
|
SELECT sum(text_val) FROM test;
|
|
|
|
-- name: GetTotalInt :one
|
|
SELECT total(int_val) FROM test;
|