如果用字符串代替查询结果?

[antoniusguo]

select col1 from tablename
col1是Int型,如果大于100就显示为'>100',否则显示'<=100'
比如原来的结果是
1
2
8
17
101
200
让他显示
'<=100'
'<=100'
'<=100'
'<=100'
'>100'
'>100'

[paoluo]

select (Case When col1 >100 Then '<=100' Else '<=100' End) As col1 from tablename

[新鲜鱼排]

select (Case col1 When col1 >100 Then '<=100' Else '<=100' End) As col1 from tablename

[paoluo]

楼上语句是错的。

[chiwei]

select
(case when coll>100 then '>100' else '<=100' end) as coll
from tablename

[chiwei]

鱼兄你的也有有笔误啊:)

[paoluo]

哈哈，还是水手你强啊！！