REP表数据:
ID VALUE
1 9
2 8
3 6
4 12
5 45
执行如下sql语句:select a.value from (SELECT value from rep where value <=8 union all (SELECT 8.0 as value from rep where value > 8)) a
查询结果为:
ID VALUE
1 8.0
2 8.0
3 8.0
4 8.0
5 6.0
另外一个语句:
select case when value>8 then 8 else value end from REP