/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

3 votes333 views1 answer
Oracle undo tablespace list by user
SQL
0 vote339 views1 answer
Postgres full text search example
SQL
4 votes341 views1 answer
Is there any command to change postgres password
SQL
22 votes375 views3 answers
Year format in date mysql
SQL
0 vote364 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote329 views1 answer
Soql more than today
SQL
0 vote377 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote343 views1 answer
How to select rows with no matching entry in another table?
SQL
1 vote319 views1 answer
Firebase bigquery cloud message
SQL
0 vote342 views1 answer
Sql clear table
SQL