/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

22 votes119 views2 answers
Mysql show all tables
SQL
0 vote129 views2 answers
Drop check constraint in ms sql
SQL
0 vote133 views1 answer
Returning with sqlalchemy
SQL
0 vote128 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
22 votes130 views3 answers
Join three tables sql
SQL
0 vote92 views1 answer
Now() -1 mysql
SQL
0 vote135 views1 answer
Database traccar
SQL
10 votes100 views2 answers
Mysql select timestamp group by day
SQL
1 vote130 views1 answer
Where date = max(date) in sql
SQL
0 vote136 views2 answers
How to save result of sqlite query in a table
SQL