/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 votes343 views1 answer
Oracle APEX elapsed time
SQL
1 vote335 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
2 votes316 views1 answer
Oracle find unusable indexes
SQL
0 vote316 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote362 views1 answer
Postgres list tables and row counts
SQL
9 votes335 views2 answers
Sql server check table exists
SQL
0 vote313 views1 answer
TSQL function split string
SQL
0 vote322 views1 answer
Add column to table with default value plsql
SQL
20 votes371 views4 answers
How to find average in sql
SQL
6 votes327 views1 answer
Sql insert values into table
SQL