/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 vote154 views1 answer
Sql trying to delete database in use
SQL
35 votes180 views5 answers
Sql alter column
SQL
22 votes201 views4 answers
Date format mysql
SQL
1 vote110 views1 answer
Python escape string for sql
SQL
0 vote180 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
8 votes161 views1 answer
Sql remove leading spaces
SQL
0 vote169 views1 answer
Sql drop default
SQL
6 votes159 views2 answers
Postgresql database url
SQL
0 vote147 views1 answer
Check index sql server
SQL
0 vote160 views2 answers
How to use aggregate functions in sql
SQL