خرید بک لینک

Vote count: 0

I have this query and it works but I know this can be simplified:

SELECT class, COUNT(class), publisher FROM books WHERE publisher = 'Company ABC' GROUP BY class
UNION
SELECT class, COUNT(class), publisher FROM books WHERE publisher = 'Company DEF' GROUP BY class
UNION
SELECT class, COUNT(class), publisher FROM books WHERE publisher = 'Company GHI' GROUP BY class
UNION
SELECT class, COUNT(class), publisher FROM books WHERE publisher = 'Company JKL' GROUP BY class
UNION
SELECT class, COUNT(class), publisher FROM books WHERE publisher = 'Company MNO' GROUP BY class;

It also hard-coded but I really want for the query to look for distinct companies in the table:

SELECT DISTINCT publisher FROM books;

Result:

publisher
Company ABC
Company DEF
Company GHI
Company JKL
Company MNO

asked 7 secs ago

برچسب: نویسنده: استخدام کار تاريخ: سه شنبه 1 تير 1395 ساعت: 7:51

صفحه بندی