Hassle-free live chat software re-imagined for business growth. 2 users, always free.
SELECT category cat1, cat cat2, COUNT(*) quantity, COUNT(CASE WHEN TYPE = 'P' THEN 1 END) type_p, COUNT(CASE WHEN TYPE = 'T' THEN 1 END) type_t FROM yourtable GROUP BY category, cat ORDER BY cat1, cat2 DESC;
|Could you possibly give a help on how to configure Datatables plugin to make it correctly runs?||5||37|
|Make custom query_posts look show the excerpt only||9||24|
|Why don't I see Below columns in my Stored Procedure under TMP_RS?||8||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!