SELECT command is used to retrieve data from one or more tables. To do so, we use the word
SELECT in our query. If we wish to add conditions or more restraints to the retrieval query, we may use nested
A nested query, i.e. a query within a query, is known as a subquery.
In the code below, there is a nested SELECT which is used to display the PersonID from the table ‘Person’. The inner select is used to view the PersonID, LastName, FirstName; it does not
SELECT City from the table. The outer
SELECT then selects the list of PersonIDs already selected by the inner
SELECT, and displays them.
This syntax can be better understood through the code below:
CREATE TABLE Person ( PersonID int, LastName varchar(255), FirstName varchar(255), City varchar(255) ); INSERT INTO Person (PersonID, LastName, FirstName, City) VALUES (1 , 'Erichsen', 'Tom', 'Newyork'), (2 , 'Cleverly', 'John', 'Texas'), (3 , 'George', 'Bill', 'Chicago'); -- Nested SELECT ------ SELECT A.PersonID FROM ( SELECT PersonID, LastName, FirstName FROM Person ) AS A;
View all Courses