I have query like below:
SELECT COUNT(*) AS AppleSupports FROM VendorItemPricing WHERE VendorName = 'Apple' SELECT COUNT(*) AS HpSupports FROM VendorItemPricing WHERE VendorName = 'HP'
Above queries give me results like below:
AppleSupports 63 HpSupports 387
How can make my query to get results in one row like below?
AppleSupports HpSupports 63 387