var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SELECT COUNT of DISTINCT
i want to do only one query for :
SELECT DISTINCT Name FROM Users
SELECT COUNT(Name) AS Names FROM Users WHERE (Name LIKE 'xxx')
something like :
SELECT Name, COUNT(Name) AS Names FROM Users WHERE Name IN (SELECT DISTINCT Name FROM Users)
i must get :
SELECT Name, COUNT(*) AS Names FROM Users GROUP BY Name
thanks once more !
Originally Posted by anselme
Of course it works...Rudy only handles the most difficult questions here at dbforums....