/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

12 votes153 views5 answers
Sql primary key
SQL
0 vote137 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote105 views1 answer
Mariadb list tables
SQL
20 votes132 views5 answers
Sql show tables
SQL
12 votes146 views1 answer
Script to add new column in table sql
SQL
0 vote137 views1 answer
Apt install sql server
SQL
0 vote146 views1 answer
Get date from timestamp in mysql
SQL
1 vote201 views1 answer
Oracle see column type
SQL
32 votes164 views6 answers
Rename column mysql
SQL
6 votes147 views2 answers
Foreign key sqlite3 python
SQL