急！急！急！急！急！

[kewudemao]

表Test 如下：
fld1 fld2 fld3
a 0 4
a 1 2
a 2 5
b 0 1
b 1 6
c 0 2
c 1 5
c 2 4
c 3 7
....
如何写出一条sql,要求返回结果满足以下条件：
1， 按fld1排序
2， fld2 = 0时fld3值最小

[hjhing]

fld2 = 0时fld3值最小 是什麼意思？？

[kewudemao]

不是，比如说fld1表示人，fld2表示该人的儿子号码，fld3表示该孩子的年纪，我要得到的结果是返回所有人的所有儿子，排序条件按照人的儿子0的年龄最小

[Sunny3141]

SELECT test.f1, test.f2, (case when test.f2 = 0 then MIN(test1.f3) else test1.f3) AS f3
FROM test LEFT OUTER JOIN
test test1 ON test.f1 = test1.f1
GROUP BY test.f1, test.f2, test1.f3

[hjhing]

你到底要按照什麼排序啊
你上面的例題
排序後是什麼樣子啊？

[pengdali]

select fld1,fld2,fld3 from 表 order by fld1,fld3

[pengdali]

select * from 表 order by fld1,fld3

[coo_key]

select * from test order by fld1,fld2

[kewudemao]

结果应该如下：
b 0 1
b 1 6
c 0 2
c 1 5
c 2 4
c 3 7
a 0 4
a 1 2
a 2 5

[hjhing]

select A.fld1,A.fld2,A.fld3
from test A ,
(select fld1,fld3 from test where fld2=0) B
where A.fld1=B.fld1
order by B.fld3 , A.fld1,A.fld2