/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

6 votes135 views1 answer
Oracle rank
SQL
0 vote128 views1 answer
Oracle enable chain
SQL
8 votes122 views2 answers
Select table column name in sql
SQL
0 vote121 views1 answer
Max length found in mysql
SQL
1 vote126 views1 answer
Python escape mysql
SQL
12 votes126 views1 answer
Docker mysql random root password
SQL
-1 vote116 views1 answer
Add column alter table default value
SQL
0 vote129 views1 answer
Mysql milliseconds
SQL
1 vote128 views1 answer
Sql select where id not exists in another table
SQL
0 vote131 views1 answer
Sql select min row
SQL