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 run google search console request submission by UI vision IDE automate?

 Run google search console request submission by UI vision IDE automate? Source View --- Json Code {   "Name": "DemoCsvReadAr...