Google Bigquery

Google Cloud Data Analytics
1

Greetings ,

Iam Rifki

I have some litte problem about syntax in Bigquery

How We using ‘Like’ order

In SQL

-SELECT *
-FROM dam13junrifki.rifkidata.transaksi
-Where Gender = ‘Male’
-and Device_Type = ‘Mobile’
-and Date Like (%2013) ;
However this not work in Bigquery

Could you all helme me guys?

Big Thanks

2

If we look here … we find that LIKE is indeed a supported comparison operator. In your question, you said that something didn’t work. Can you elaborate on that? Can you describe exactly what you tried and exactly what the error symptom was?

3

Thanks for respond

i have got the answer :

SELECT *
FROM dam13junrifki.rifkidata.transaksi
where gender = ‘Male’
and Device_Type = ‘Mobile’
and Product = ‘Books’
and Customer_Login_type = ‘Member’
and EXTRACT(YEAR FROM date) = 2014
and EXTRACT(MONTH FROM date) = 01

i must use "extract’ syntax to determine the year or date that i want to know