求助sql 问题，都有分

[shenjhshen]

ftime day month f1(都是integer)
1 1 1 12
2 1 1 27
3 1 1 45
4 1 1 78
1 2 1 12
2 2 1 217
3 2 1 122
4 2 1 34
1 3 1 112
2 3 1 227
3 3 1 172
4 3 1 237
1 4 1 152
2 4 1 227
3 4 1 192
4 4 1 127
..........................
.........................
怎么有sql 把月的每一天的最大的f1都求出了，急呀！！！

[ddvboy]

是取出来吧
select max(f1) from table where day:=old day
其中OLD DAY 是你要输入的天数

[zjhydx98]

select max(f1) from table1 group by day

[treesman]

你怎么在这问这个问题呢？你该去SQLSER那问

[ilang]

select Max(fl) iTemp from TableName

[treesman]

up

[shenjhshen]

老兄门，一月30天呀，要找的的是月

[dreamfan]

select max(f1) from table1 group by day

[gxyc76]

select month,day,max(f1)
from table1
group by month,day

[shenjhshen]

是不是要用到存储结构，看清楚，找出每月的所有天数中的最大f1，输入月后至少一次要显示28天记录。

[9igogo]

select max(f1) from table1 where month=:month group by day
就把month这个月每一天的最大值取出

[chenooo]

select Max(fl) from Table1 where month=:yourmonth group by day

[爱编程的老五]

select year, month, max(f1) from table1 group by year, month

[爱编程的老五]

你要求每天是吧?
select year, month, day max(f1) from table1 group by year, month, day.
刚才错了.

[qiume]

up

[shengs]

select ftime,month,day,max(fl) from talbe1 group by day,month