In this chapter, we've introduced our first SQL statement, the
SELECT statement, examined its syntax, and explored how it can be used in the process of column projection. We've seen the use of the
SELECT statement in projecting single columns and multiple columns. We have looked at the
DESCRIBE command and how it can be used to display the column names for a table. We've covered the use of aliases in changing column headings and used arithmetic operators to execute mathematical calculations on table data. We've examined the concept of NULL and demonstrated how to retrieve unique rowsets using
DISTINCT. Finally, we've used the double pipe symbol to concatenate string literals with table values.