/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 votes197 views2 answers
How to load files in mysql
SQL
0 vote196 views1 answer
Sql server size of every table in a db
SQL
0 vote197 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote223 views1 answer
Add user mysql wordpress
SQL
0 vote185 views1 answer
Mysql autoincrement valor inicial
SQL
1 vote194 views1 answer
How to test for sql injection
SQL
0 vote189 views1 answer
Get employees if not contains in sql
SQL
0 vote195 views1 answer
What is ssrs and ssis in sql server
SQL
1 vote215 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote212 views1 answer
Psotgres multiple values
SQL