sql如何 去掉重复，详细请看

[selboo]

我有一个表 biao3 里面有两列 lie26 lie27
lie26 lie27
2 1
2 2
2 3
2 4
45 8
45 9
45 7
45 64
68 48
68 23
777 48
777 j
777 54u

select lie26 from biao3

结果lie26 有很多重复的，下面是运行结果

lie26
2
2
2
2
45
45
45
68
68
777
777
777

我想让它去掉重复的，让它一列只显示一个，比如下面是我想要的结果

lie26
2
45
68
777

[internetroot]

select distinct lie26 from biao3

[marco08]

select lie26 from biao3
group by lie26

[-狙击手-]

select distinct lie26
from biao

[青锋-SS]

select lei26 from biao3 group by lei26

[一品梅]

select dinstinct(lie6) from biao3;

[青锋-SS]

select lie26 from biao3 union select lie26 from biao3

[internetroot]

估计你是想要这种效果

select lie26=(case when lie27=(select min(lie27) from biao3 where lie26=t.lie26) then lie26 else null end) 
	   ,lie27
from biao3 t

[fzcheng]

SELECT lie26,SUM(lie27)AS lie27 FROM biao3 GROUP BY lie26 ORDER BY lie26

[selboo]

2楼的，就可以了
简单，就是我想要的结果

怎么给分呀？？