/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 vote227 views1 answer
Nuget sqllite-net-pcl
SQL
11 votes340 views2 answers
Import mysql dump command line windows
SQL
7 votes178 views1 answer
Alter table add key sql
SQL
8 votes201 views1 answer
Oracle find text in functions
SQL
0 vote206 views1 answer
Json not contains mysql
SQL
11 votes204 views1 answer
Get ddl materialized view oracle
SQL
0 vote203 views2 answers
Null value in column violates not-null constraint
SQL
3 votes200 views1 answer
Two select sql
SQL
7 votes284 views2 answers
Phpmyadmin change password
SQL
8 votes200 views1 answer
Today minus 15 days postgresql
SQL