Data retrieval using the SQL SELECT statement
Capabilities of the SELECT statement
Relational database tables are built using relational theory. Relational theory uses relational algebra formal language.
According to relational theory SELECT statement uses three concepts:
Projection - restriction of columns to...