SyntaxFix

[sql] SELECT query with CASE condition and SUM()

To get each sum in a separate column:

Select SUM(IF(CPaymentType='Check', CAmount, 0)) as PaymentAmountCheck,
       SUM(IF(CPaymentType='Cash', CAmount, 0)) as PaymentAmountCash
from TableOrderPayment
where CPaymentType IN ('Check','Cash') 
and CDate<=SYSDATETIME() 
and CStatus='Active';

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to sum

• Iterating over arrays in Python 3 • Get total of Pandas column • Pandas: sum DataFrame rows for given columns • How to find sum of several integers input by user using do/while, While statement or For statement • SQL Sum Multiple rows into one • Python Pandas counting and summing specific conditions • SELECT query with CASE condition and SUM() • Using SUMIFS with multiple AND OR conditions • How to SUM parts of a column which have same text value in different column in the same row • how to count the total number of lines in a text file using python

Examples related to case

• PostgreSQL CASE ... END with multiple conditions • SQL Server: use CASE with LIKE • SQL Server IIF vs CASE • SELECT using 'CASE' in SQL • SELECT query with CASE condition and SUM() • GROUP BY + CASE statement • SQL use CASE statement in WHERE IN clause • SQL Server - Case Statement • where to place CASE WHEN column IS NULL in this query • Regarding Java switch statements - using return and omitting breaks in each case

Examples related to conditional-statements

• How to have multiple conditions for one if statement in python • Excel - programm cells to change colour based on another cell • Using OR & AND in COUNTIFS • C error: Expected expression before int • Conditional Replace Pandas • SELECT query with CASE condition and SUM() • Simpler way to check if variable is not equal to multiple string values? • Replace all elements of Python NumPy Array that are greater than some value • How can I check if a string only contains letters in Python? • Check if year is leap year in javascript