2021. már 15.

Variables in Bigquery

írta: dataanalyticsdemo
Variables in Bigquery

declare lower_limit int64 default 1;
set lower_limit = 1500;

SELECT * FROM `bigquery-public-data.medicare.outpatient_charges_2011`
where average_total_payments > lower_limit
order by average_total_payments desc

 

DECLARE arr ARRAY<INT64> default [1,2,3];
SELECT ARR[OFFSET(1)] AS RES;

Szólj hozzá