How can I get the count of 2 columns such that there are distinct combinations of two columns?
Select count(distinct cola, colb)
SELECT COUNT(*)
FROM (
SELECT DISTINCT a, b
FROM mytable
)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With