/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 votes324 views1 answer
Mysql load sql from file
SQL
0 vote328 views1 answer
How to query all tables mysql at the same time
SQL
0 vote439 views1 answer
Sp help text in postgresql
SQL
13 votes345 views2 answers
Sql online compiler
SQL
0 vote322 views1 answer
Sql orcale i forgot what my name & password was
SQL
-2 votes359 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote318 views1 answer
Mysql command prompt date insert format
SQL
0 vote345 views1 answer
How we can perform acid Operations in sql with examples
SQL
3 votes334 views2 answers
Brew start mysql
SQL
0 vote340 views1 answer
Mariadb select limit offset
SQL