How to count rows with distinct values on any of the three columns: col1
, col2
, col3
?
views:
73answers:
2it works! thanks you!
lovespring
2009-12-15 15:39:01
A:
Blind kick:
SELECT count(*) FROM YourTable
WHERE Col1 <> Col2 OR Col1 <> Col3 OR Col2 <> Col3
Rubens Farias
2009-12-15 15:28:08