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;
Read More Posts
- How do you round to 1 decimal place in Javascript (roundup)?
- How to remove required attribute from text field with jquery?
- How to create Page Template Plugin in wordpress?
- How to get default value from input field in jquery?
- How to insert data from dynamically created add/remove fields in wordpress $wpdb? (second method)