Top "Sql-standards" questions

Split string at specific character SQL-Standard

In my SQL statement I have to extract a substring from a string at the character '_'. Strings can …

string postgresql string-split sql-standards

BigQuery standard SQL: how to group by an ARRAY field

My table has two columns, id and a. Column id contains a number, column a contains an array of strings. …

arrays string group-by google-bigquery sql-standards

Why do I need to explicitly specify all columns in a SQL "GROUP BY" clause - why not "GROUP BY *"?

This has always bothered me - why does the GROUP BY clause in a SQL statement require that I include …

sql group-by aggregate ansi-sql sql-standards