SQL Notes – SELECT and PROJECT

I’m trying to wrap my mind around SQL.

We learned that there are two functions when dealing with only one table: selection and projection.
Where Selection retrieved information from the rows and Projection retrieves information from the columns.

This is the example she used in class:

If you want to retrieve the Students names where rating is less than 8, you would type this SQL command:

SELECT sname
FROM Applicant
WHERE rating < 8
;

If you wanted to retrieve the Student ID and Name where age is greater than 24, you would type this SQL command:

SELECT ID, sname
FROM Applicant
WHERE age > 24
;

Advertisements