/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 vote343 views1 answer
Rabbitmq service not starting
SQL
0 vote395 views1 answer
SQL Cut part string
SQL
0 vote345 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
3 votes384 views1 answer
Increment integer in table sql
SQL
7 votes372 views5 answers
Show details of table postgres
SQL
0 vote410 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote374 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote349 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote349 views1 answer
Get last updated row sql server
SQL
0 vote447 views1 answer
How to check foreign key constraint in sql
SQL