05-22-2018 01:51 PM
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 :)
05-31-2018 09:25 AM
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;