Using the CASE Statement in SQL Server

SQL CASE statement with multiple conditions

CASE with the ORDER BY clause

CASE with the GROUP BY clause

CASE with INSERT and UPDATE

Using CASE WHEN with SUM()

Conclusion

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store