By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,660 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,660 IT Pros & Developers. It's quick & easy.

sql query groups and min value

P: 2
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.
Nov 4 '09 #1
Share this Question
Share on Google+
2 Replies


Delerna
Expert 100+
P: 1,134
what have you tried so far?
Nov 5 '09 #2

P: 2
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.. :)
Nov 5 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.