add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
highlight batch
db<>fiddle
Db2
Firebird
MariaDB
MySQL
Node.js
Oracle
Postgres
SQLite
SQL Server
TimescaleDB
YugabyteDB
Developer-C 11.1
3.0
4.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
5.5
5.6
5.7
8.0
18
11g Release 2
18c
21c
23c
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
3.8
3.16
3.27
3.39
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2.11
2.14
2.6
2.8
2.18
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run
markdown
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
CREATE TABLE #XX (ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY, VAL1 INT, VAL2 INT, VAL3 INT, VAL4 INT, VAL5 INT) INSERT INTO #XX (VAL1,VAL2,VAL3,VAL4,VAL5) VALUES (5,10,NULL,17,12), (12,12,12,NULL,0), (15,15,15,15,15), (3,NULL,6,0,NULL), (10,NULL,15,0,20) ;WITH cte AS ( SELECT id, ValueNumber, Value FROM (SELECT id, val1,val2,val3,val4,val5 from #XX) v UNPIVOT (Value FOR ValueNumber IN(val1,val2,val3,val4,val5)) AS unpvt) SELECT DISTINCT v1.id FROM cte v1 INNER JOIN cte v2 ON v1.id = v2.id WHERE v1.value <> v2.value AND v1.ValueNumber <> v2.ValueNumber AND v1.Value <> 0 AND v2.Value <> 0
id
1
4
5