/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 vote128 views2 answers
What is the default password for sql server sa
SQL
0 vote109 views1 answer
Except in sql
SQL
0 vote117 views1 answer
Changer un mot de passe mysql
SQL
0 vote115 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote108 views1 answer
Set statistics on in ssms
SQL
4 votes109 views2 answers
Insert current date in mysql
SQL
1 vote116 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote125 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote115 views1 answer
Openquery join two tables
SQL
1 vote123 views1 answer
Mysql backup skip table
SQL