Breaking News: Grepper is joining You.com. Read the official announcement!

XOR in SQL Server

MazelTov27 answered on March 29, 2022 Popularity 9/10 Helpfulness 7/10

answer XOR in SQL Server

related sql xor

XOR in SQL Server

Comments(1)

SELECT name
    , population
    , area
FROM world
WHERE (area > 3000000 AND population <= 250000000)
OR (area <= 3000000 AND population > 250000000)

Popularity 9/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: sql sql-server xor

Link to this answer
Share Copy Link

Contributed on Mar 29 2022

MazelTov27

0 Answers Avg Quality 2/10

Closely Related Answers

sql xor

Comment

A xor B = (not A and B) or (A and not B)


A B | f = notA and B | g = A and notB | f or g | A xor B    
----+----------------+----------------+--------+--------    
0 0 | 0              | 0              | 0      | 0    
0 1 | 1              | 0              | 1      | 1    
1 0 | 0              | 1              | 1      | 1    
1 1 | 0              | 0              | 0      | 0

Popularity 9/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: sql xor

Link to this answer
Share Copy Link