求思路：取值为前3位的平均值的sql

[MagicJohn]

如题。谢了先

[灯火GG]

select avg(substring(Field,1,3)) from table group by field

[DJMPH]

select avg(a) from (select top 3 a from table order by a) as table

[pengdali]

select avg(left(字段,3)) from 表 group by left(字段,3)

[pengdali]

select avg(left(字段,3)) 平均值 from 表

[happydreamer]

select avg(cast(left(字段,3) as int)) 平均值 from 表

[joygxd]

select avg(cast(left(field,3) as dec)) form table

[CrazyFor]

select avg(值) from (select top 3 * from table order by 值 desc)tem gropy by 名字。

[MagicJohn]

多谢，结账了。