＋设为首页 ＋添加到收藏夹
http://expert.csdn.net/Expert/topic/1707/1707086.xml?temp=.9515192
刚刚结了贴的
我用了pengdali(大力) 的方法：
SELECT au_fname, au_lname,
CASE state
WHEN CA THEN (SELECT COUNT([SpecialPrice]) FROM [Product])
WHEN KS THEN Kansas
WHEN TN THEN Tennessee
WHEN OR THEN Oregon
WHEN MI THEN Michigan
WHEN IN THEN Indiana
WHEN MD THEN Maryland
WHEN UT THEN Utah
END AS StateName
FROM pubs.dbo.authors
ORDER BY au_lname
但现在我还要更改一下
把(SELECT COUNT([SpecialPrice]) FROM [Product])
改成条件的
如
if(a>b)
(SELECT COUNT([a]) FROM [Product])
else if (b>c)
(SELECT COUNT([b]) FROM [Product])
else
(SELECT COUNT([c]) FROM [Product])
怎么改？？
select (case when a>b then (select count([a]) from [product])
when b>c then (select count([b]) from [product])
else (select count([c]) from [product])
end ) as your
select (case when a>b then (select count([a]) from [product])
when b>c then (select count([b]) from [product])
else (select count([c]) from [product])
end ) as your
SELECT au_fname, au_lname,
CASE state
WHEN CA THEN (SELECT COUNT(case when a>b then a when b>c then b else c end) FROM [Product])
WHEN KS THEN Kansas
WHEN TN THEN Tennessee
WHEN OR THEN Oregon
WHEN MI THEN Michigan
WHEN IN THEN Indiana
WHEN MD THEN Maryland
WHEN UT THEN Utah
END AS StateName
FROM pubs.dbo.authors
ORDER BY au_lname
