/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

3 votes202 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote202 views1 answer
Nueva tabla mysql
SQL
0 vote202 views1 answer
Syntax for changing column size in mysql
SQL
0 vote201 views1 answer
Postgress append string in select
SQL
0 vote203 views1 answer
Sql server beginning of month
SQL
1 vote174 views1 answer
Python escape string for sql
SQL
1 vote200 views1 answer
Import local sql into remote mysql
SQL
-1 vote192 views3 answers
Mysql get age from date
SQL
1 vote190 views1 answer
How to get mysql db size
SQL
0 vote208 views1 answer
How to input data as id in database sql c#
SQL