sql query groups and min value

franc

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.

Delerna

what have you tried so far?

franc

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.. :)

sql query groups and min value

re: sql query groups and min value

re: sql query groups and min value

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about