How to use DELETE statement in SQL | BigQuery

How to use DELETE statement in SQL | BigQuery

Pivotalstats

1 год назад

1,277 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@user-hj7eu6rz2k
@user-hj7eu6rz2k - 05.06.2023 18:49

Hi Bro,
Can I delete duplicate data from Big query table?
If possible, Please let me know.

Ответить
@HamzaKhan-bt5vg
@HamzaKhan-bt5vg - 26.10.2023 18:22

Hi Bro,
I am in a situation where I need to delete rows based on join, I cannot find any such example in the official documentation, can you help?

I am trying to replicate the query below that I found on stackoverflow, what would be the alternative in BQ?

DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'

Ответить
@vadapallichaitu8799
@vadapallichaitu8799 - 29.12.2023 11:20

I am having streambuffer issues ,how to handle this

Ответить