Sql

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

PREVIOUS	NEXT

Code Example
Sql :: query saurce oracle
Sql :: postgresql left join distinct on
Sql :: mysql start command
Sql :: list all the tables in sql
Sql :: drop multiple databases mysql
Sql :: insert value in identity
Sql :: postgres change column type to uuid
Sql :: mysql check if not null
Sql :: sql add column after another column
Sql :: delete top N rows in sql
Sql :: mysql date time string format python
Sql :: sql where first letter
Sql :: sql backup database statement
Sql :: install mysql in ubuntu
Sql :: mysql average of multiple columns
Sql :: calculate distance between two latitude longitude points sql
Sql :: postgresql create user
Sql :: mysql error 1251
Sql :: mysql set password for user
Sql :: mysql add column with default value
Sql :: min salary in sql
Sql :: postgresql export database
Sql :: oracle nextval
Sql :: sql declare table variable
Sql :: clear screen command on mysql
Sql :: sql case
Sql :: how to insert ip address in mysql using php
Sql :: how to combine first and last nae into one columb sql
Sql :: drop temp table if exists
Sql :: mariadb hours between two dates