Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle sql group by date year

SELECT value1, extract(YEAR FROM my_date)
FROM my_table
GROUP BY value1, extract(YEAR FROM my_date);
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #oracle #sql #group #date #year
ADD COMMENT
Topic
Name
6+4 =