Views aren’t complicated – if you’ve got half an hour, we’ll get you started writing SQL queries using views! Let’s start by answering the question “What is a view in SQL?’. A view is a database object (as is a table, an index, or a stored procedure). Like a table, you can query a view and extract the information in it. It can be used in the FROM clause of a SELECT, and you can reference view columns in clauses like SELECT, WHERE and GROUP BY among other clauses as well.
What happens when you combine CASE with SQL’s data modifying statements? Find out in this article. The CASE expression is a very useful part of SQL and one that you’ll employ frequently. We’ve already covered what the CASE expression does, how to format it, and how to use it in a SELECT statement in “Using CASE to Add Logic to a SELECT”. Another article, “How to Sort Records with the ORDER BY Clause” demonstrated how to use CASE in an ORDER BY clause.