SQL SERVER中如何求两个已知数的最小值.(30分)

D

driayu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #1

比如有A,b两个整数,在SQL SERVER中,如何返回最小值?

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #2

CASE WHEN A>b THEN A  ELSE  b END AS 最小值

 

D

driayu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #3

to power255<br>由于我的A由一很复杂的SQL 语句求得的结果,如果用你这方法,那也就是说,我的那求A值的SQL语句要写两次?<br>比如:<br>A值的SQL 语句为:<br>Select Min(Field1) from Table1........<br>那照你的方法,我应该用下面语句<br>Select (Case Where (Select Min(Field1) from Table1........)&gt;B then b else<br>(Select Min(Field1) from Table1........) end.) 这样是不是太麻烦了?有没有更简便点的方法.

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #4

你把它写在外面，<br>select CASE WHEN A&gt;b THEN A &nbsp;ELSE &nbsp;b END AS 最小值,其它字段 from (复杂的SQL)

 

C

crazyflash

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #5

写一个function最简单

 

D

driayu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #6

多人接受答案了。