Running a SELECT statement, assuming that there’s no error, gives you a result. That result is a virtual table, and it will have rows and columns.
For our purposes, we are interested in three possible virtual tables:
-
One row and one column: You get just one value, though technically it’s still in a table. We’ll call this a single value.
-
One column and multiple rows: When the time comes, we’ll call this a list.
-
Multiple rows and multiple columns: In this context, a single row with multiple ...
