The SELECT Command is used to retrieve information from a database. There are various ways in which the SELECT command can be used. Syntax of SELECT Command is as follows:
SELECT <attribute list>
FROM <table list>
WHERE <condition>
The basic structure of a SELECT command comprises of the keyword SELECT followed by the attribute list (separated by comma (,)) you want to select, followed by FROM clause followed by the table name and lastly an optional WHERE clause which is followed by a condition that can be a Boolean expression or another SELECT command that identifies the tuples to be selected.
Consider the following tables in the School Database for all the queries that follow:
The Teacher table refers Department table to keep track of the department to which a teacher belongs.
