34,587
社区成员
发帖
与我相关
我的任务
分享help!如何写SQL语句?
在MSSQL SERVER 中一表MYTABLE (例如有A,B两列都是INT 型)
我想返回一列值,每一记录取A,B中最小值
请问如何写SQL语句?
我想返回一列值,每一记录取A,B中最小值
请问如何写SQL语句?
...全文
请发表友善的回复…
发表回复
zcw 2000-09-02
- 打赏
- 举报
saipm is all right.
JGTM2000 2000-09-02
- 打赏
- 举报
saipm is all right.
huntout 2000-09-01
- 打赏
- 举报
declare @a int
declare @b int
select @a = min(A) from MYTABLE
select @b = min(B) from MYTABLE
select minA = @a, minB = @b
declare @b int
select @a = min(A) from MYTABLE
select @b = min(B) from MYTABLE
select minA = @a, minB = @b
saipm 2000-09-01
- 打赏
- 举报
用这条语句吧：
select (case when A<=B then A else B end) As aNewColName from MyTable
其中aNewColName 是你需要的新列
select (case when A<=B then A else B end) As aNewColName from MyTable
其中aNewColName 是你需要的新列
iamxia 2000-09-01
- 打赏
- 举报
我想可能要用到临时表来倒出结果。
SELECT A，B A-B DIFF, 0 MYMIN
INTO #TEMP1
FROM MYTABLE
UPDATE #TEMP1
SET MYMIN = A
WHERE DIFF >= 0
UPDATE #TEMP1
SET MYMIN = B
WHERE DIFF < 0
临时表中的MYMIN就是要求出的结果。
SELECT A，B A-B DIFF, 0 MYMIN
INTO #TEMP1
FROM MYTABLE
UPDATE #TEMP1
SET MYMIN = A
WHERE DIFF >= 0
UPDATE #TEMP1
SET MYMIN = B
WHERE DIFF < 0
临时表中的MYMIN就是要求出的结果。
icedian 2000-09-01
- 打赏
- 举报
先要看table是否有记录，
如table中没有记录，你会发现取出的值，既不是null,也不是0.
declare @row_count
select @row_count=count(*) from MYTABLE
if @row_count=0
...
如table中没有记录，你会发现取出的值，既不是null,也不是0.
declare @row_count
select @row_count=count(*) from MYTABLE
if @row_count=0
...
