/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 vote135 views2 answers
Suse Linux restart MySQL
SQL
0 vote113 views1 answer
Difference between db.query and db.execute
SQL
0 vote113 views1 answer
Ansi sql count duplicate rows
SQL
0 vote99 views1 answer
Search In the Database using Text
SQL
0 vote115 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote113 views1 answer
Create table database in psql
SQL
3 votes106 views4 answers
Stop MySQL
SQL
0 vote108 views1 answer
What is metadata in sql
SQL
0 vote161 views1 answer
MySQL update with subquery
SQL
1 vote126 views1 answer
Postgres see sequence current state
SQL