Using Case statement to compare two columns in SQL Server

AliYilma...

SOLVED CLOSED ACTIVE ANSWERED
User: AliYilmaz
Posted: on Dec 06, 2021 01:47 AM
Forum: SQL Server
Answer: 1
Views: 1878

Hi,

I will do case when in sql. But I will compare the 2 columns and do it.

So if a query is true, this query should work. If the other query is correct, let this query work.

CASE Kode=true
 WHEN
THEN
ELSE
END AS Kolon
 WHEN
THEN
ELSE
END AS Kolon
 WHEN
THEN
ELSE
END AS Kolon
 WHEN
THEN
ELSE
END AS Kolon

CASE Kode=false
 WHEN
THEN
ELSE
END AS Kolon
 WHEN
THEN
ELSE
END AS Kolon
 WHEN
THEN
ELSE
END AS Kolon
 WHEN
THEN
ELSE
END AS Kolon

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Dec 06, 2021 03:29 AM
Modified: on Dec 06, 2021 03:30 AM
Report

Hi AliYilmaz,

Refer below query.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

SQL

-- Using AND condition
SELECT
	FirstName,
	CASE 
	WHEN Country = 'USA' AND ReportsTo = 2 
		THEN '1' 
	ELSE 
		'0' 
	END [Status]
FROM Employees

Output

FirstName	Status
Nancy	1
Andrew	0
Janet	1
Margaret	1
Steven	0
Michael	0
Robert	0
Laura	1
Anne	0

SQL

-- Using nested case expression
SELECT 
	FirstName,
    CASE Country
	WHEN 'USA' 
	THEN  
		CASE 
		WHEN ReportsTo = 2 
		THEN 
			'1' 
		ELSE 
			'0'
		END
    ELSE 
		'2'
    END [Status]
FROM Employees

Output

FirstName	Status
Nancy	1
Andrew	0
Janet	1
Margaret	1
Steven	2
Michael	2
Robert	2
Laura	1
Anne	2

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Using Case statement to compare two columns in SQL Server

Company

Explore

Follow us

Contact Us