I have a column : DATE, LOC_NO, PART_NO. The query is grouped by PART_NO, I want a query prioritized by the MIN(DATE). I need also the value of LOC_NO but I don’t care the value returned, then I used MIN(LOC_NO).
My question is, is the order of min() function is matters ? I want the most priority is MIN(DATE).
So my query is : SELECT PART_NO, MIN(DATE), MIN(LOC_NO)
instead of SELECT PART_NO, MIN(LOC_NO), MIN(DATE)
?