Hi,
I have a categories column and a title column in one table. What I'm trying to do is select the most frequently listed title for each category. I would think that this sql statement would do, but it just returns every column.
select count(title) from table where title IN (select title from table where category = 'category');
To me the inner select should select every title that has a category = 'category'. Then the outside select should display a count of each title that has that one category listed in the inner select.
Any help is appreciated. Thanks
