28 November 2019

How to get all unique years from a date column using Sql(Mysql)?

 Get all unique years from a date column using Sql(Mysql)?



SELECT distinct year(OrderDate) FROM Orders;



SELECT distinct year(column_name) FROM table_name;

No comments:

Post a Comment

How to fetch instagram posts data?

Fetch Instagram posts data by pasting this code in browser console. (() => { /* ====================================================...