Hi, all!
My question is: I have database and I make 'SELECT DISTINCT...' for it. I need to count the number of returned rows. Something like:
SELECT COUNT(DISTINCT(name)) FROM...
Looks like this expression does not work. So, don't you know what to do? How can I count the number of rows returned by DISTINCT select statement?
My question is: I have database and I make 'SELECT DISTINCT...' for it. I need to count the number of returned rows. Something like:
SELECT COUNT(DISTINCT(name)) FROM...
Looks like this expression does not work. So, don't you know what to do? How can I count the number of rows returned by DISTINCT select statement?