I'm looking for a solution to restrict my data table based on year. What is the correct syntax for achieving this?
SELECT [column] FROM database IN('yyyy')
Help please :)
What the type of the column you want to restrict it? is it a TIMESTAMP column?
If it's a TIMESTAMP or STRING try to use this:
select [column] from [table] where extract(year from [column]) is not null;