SELECT * From Badges LEFT JOIN Users on Badges.Id = Users.Id

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TagName,
CASE
WHEN TagName = 'windows-xp' THEN 'Desktop'
WHEN TagName = 'windows-8' THEN 'Desktop'
WHEN TagName = 'windows-10' THEN 'Desktop'
ELSE 'Unkown'
END AS DEVICE
FROM TAGS
WHERE TagName in 
('windows-xp', 'windows-8', 'windows-10', 'ios', 'android', 'blackberry')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results