Using SQL, Return other fields with aggregate function
I have been unsuccessful in retrieving a min. or max value from a field along with other fields, like a date.
I'm trying to get a min (or max) value, which is easy enough, but I also want to be able to access other fields in the record, such as a date when the min. occurred. That part I haven't been able to figure out.
I've tried together like: "SELECT MIN(\"E Used\"),\"Read Date\" FROM \"Data\" WHERE \"E Used\" > 0 GROUP BY \"Read Date\" HAVING \"E Used\" = MIN(\"E Used\")"
And in two separate: M="SELECT MIN(\"E Used\") FROM \"Data\" WHERE \"E Used\" > 0"