I have a table with columns of names 'Name', 'Product', 'Value', 'Update Date'. I want to have an SQL statement that selects the unique values of the columns 'Name', 'Product', 'Value' but do so in a way that they are ordered by most recent to least recent 'Update Date.'
If I return the output of such an SQL select statement, I could easily get, let's say the three Names or the three Products, three Values, that had the most recent updates. Is there an SQL statement I could use?
I am thinking about having a separate SQL statement for each of the columns: 'Name', 'Product', 'Value'. And have an ORDER BY statement somewhere. Any thoughts?