a.. jes... found a good link how to solve my problem.. at http://www.xaprb.com/blog/2006/12/07...-group-in-sql/
just couldn't type my question right in the google... am really not any good at sql... thanks anyway.. :)
franc
Last Activity: Nov 5 '09, 09:31 AM
Joined: Nov 4 '09
Location:
-
sql query groups and min value
Hi,
got a problem formulating sql query.
I got a table with datetime column and a double(float) column.
I set datetime interval, then the interval gets broken down to n equal timespans, then i select the minimum value row from interval.
end result is n rows with minimum double value, one each from each timespan..
any ideas??
with regards
Fr.
No activity results to display
Leave a comment: