/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

1 vote346 views1 answer
How to see logical reads in sql server
SQL
0 vote294 views1 answer
Mysql installer no packages found
SQL
0 vote324 views1 answer
Generate random & unique mysql string
SQL
2 votes290 views2 answers
Postgres set user as superuser
SQL
0 vote313 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
4 votes366 views4 answers
Check constraint in ms sql
SQL
15 votes289 views2 answers
How to drop database name in postgresql
SQL
1 vote320 views1 answer
How to subtract from the value of a table in sql
SQL
-1 vote291 views2 answers
Full join sql
SQL
22 votes298 views4 answers
Show list of users in mysql
SQL