sql select语句中的用例 [英] Using case in a sql select statement

问题描述

考虑一个具有列数的表，

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屋！