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 create video slider with cuncks of videos without download all videos?

 Create video slider with cuncks of videos without download all videos function custom_video_slider_shortcode() { $slider_id = 'vide...