/SQL/Sql group by year

Sql group by year

Sql group by year

SELECT value1, extract(YEAR FROM my_date)
FROM my_table
GROUP BY value1, extract(YEAR FROM my_date);

4

Similar codes

0 vote165 views1 answer
Check index sql server
SQL
0 vote175 views1 answer
Adding primery key constraint to a column
SQL
0 vote335 views1 answer
Sql change a colum to unique
SQL
2 votes184 views1 answer
Guid to string sql
SQL
0 vote176 views1 answer
Min salary in sql
SQL
0 vote175 views1 answer
Mysql update privileges
SQL
4 votes303 views1 answer
What are the data types
SQL
18 votes139 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote173 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
2 votes183 views2 answers
Mysql count rows returned
SQL

Share