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 add re-captcha v3 on all Elementor forms using coding?

 Add re-captcha v3 on all Elementor forms using coding add_action('wp_footer',function(){     ?> <script src="https://www...