SQL选择“不同的值”，但按不同的值排序

I want to select all distinct order_ids from my table, and order that list by the date column. Using DISTINCT is of course a query-wide parameter, so trying something like this doesn't work:I want to select all distinct order_ids from my