/SQL/BigQuery Remove Duplicate Keys From Table

BigQuery Remove Duplicate Keys From Table

#standardSQL
CREATE OR REPLACE TABLE `myproject.datasetID.tableID` AS
SELECT * FROM (
  SELECT AS VALUE ANY_VALUE(new_table)
  FROM `myproject.dev.sample` AS new_table
  GROUP BY key1 #,key2
)

Source: stackoverflow.com

Similar codes

1 vote113 views2 answers
Sql multiline comment
SQL
0 vote95 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote132 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote102 views2 answers
Zsh: command not found: mysq
SQL
1 vote107 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
10 votes112 views2 answers
Show tables in schema oracle
SQL
0 vote104 views1 answer
Oracle sql procedure return value
SQL
0 vote116 views1 answer
Mysql custom sort order
SQL
0 vote220 views1 answer
The differnece between to values in sql
SQL
0 vote93 views1 answer
Export partttion and import in oracle
SQL