ÇóÒ»SQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

Êý¾Ý¿â±íA
ID Weight VolWeight
1 10 6
2 5 8
3 1 3
4 12 7
5 11 2
6 3 5

ÐèÒªµÃµ½ÈçϱíÄÚÈÝ,ÒªÔõÑùʵÏÖ
ID OUTWeight 
1 10
2 8
3 3
4 12
5 11
6 5

---

SQL code:
select id, case when weight>volweight then weight else volweight end OUTweight
from [Table]

---

SQL code:
select id , OUTWeight = (case when Weight > VolWeight then Weight else VolWeight end ) from a

---

ÒýÓÃ

SQL code
select id, case when weight>volweight then weight else volweight end OUTweight
from [Table]

up

---

SQL code:
create table a (ID int,Weight int,VolWeight int)
insert into a values(1 ,10, 6)
insert into a values(2 ,5 ,8)
insert into a values(3 ,1 ,3)
insert into a values(4 ,12, 7)
insert into a values(5 ,11, 2)
insert into a values(6 ,3 ,5)
go

--1
select id , OUTWeight = (case when Weight > VolWeight then Weight else VolWeight end ) from a

--2
select id