/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

0 vote217 views1 answer
Sql trigger to call stored procedure with parameters
SQL
3 votes185 views3 answers
Restart mysql mac
SQL
0 vote130 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote164 views1 answer
How to delay stored procedure execution in sql server
SQL
23 votes134 views6 answers
How to create table in sql
SQL
0 vote143 views3 answers
Condition in count sql
SQL
6 votes130 views4 answers
Eloquent to sql with bindings
SQL
0 vote139 views1 answer
Sql grant select only
SQL
11 votes262 views2 answers
Import mysql dump command line windows
SQL
0 vote141 views1 answer
Oracle sql developer closed connection
SQL