sql select语句中的用例 [英] Using case in a sql select statement
本文介绍了sql select语句中的用例的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
考虑一个具有列数的表,
Consider a table with a column amount,
Amount
-1235.235
1356.45
-133.25
4565.50
5023
-8791.25
我希望我的结果窗格是这样,
I want to my result pane to be like this,
Debit Credit
0 -1235.235
1356.45 0
0 -133.25
这是我的存储过程,
USE [HotelBI_CustomDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_GetJVReport](
@p_FromDate datetime,
@p_ToDate datetime
)
AS
BEGIN
select jv.AccountNo,jv.AccountNoTitle,(select JV_GroupsHead.GroupTitle
from JV_GroupsHead where JV_GroupsHead.Id=jv.GroupId) as 'GroupName'
,jv.Revenue --" This column i need to check and have to split it into two
column "credeit,debit""
from JVFunction1(@p_FromDate,@p_ToDate) as jv
END
如何编写一个选择语句,使其使用诸如金额> = 0"作为贷方,而金额<0"作为借方的情况?
How to write a select statement such that it uses a case like amount>=0 as credit and amount <0 as debit?
推荐答案
根据实际需要进行修改
SELECT
CASE WHEN Amount < 0 THEN ABS(Amount) ELSE NULL AS Debit,
CASE WHEN Amount >= 0 THEN Amount ELSE NULL AS Credit
FROM
SomeTable
这篇关于sql select语句中的用例的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文