Database Systems with SQL - Full Course - Database Systems - The SELECT Statement - SELECT * FROM Table WHERE Condition

To query a database, you use the SELECT statement specifying the columns you need, and the FROM clause specifying the table to get it from. The data that is returned is referred to as a result set, and the data is stored in a result table. If you say SELECT * FROM TableName, then it will return all rows from the specified table. If you need to specify a condition, use the WHERE clause. Examples: SELECT * FROM Movie; SELECT Title, ReleaseDate FROM Movie WHERE ReleaseDate = 1990; SELECT Title FROM Movie WHERE ReleaseDate = 1990 AND Rating = ‘R’; SELECT Name, Goals1stHalf + Goals2ndHalf FROM Player WHERE Team = ‘Soccer Stars’ ; The WHERE clause supports comparison, logical, and arithmetic operators Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!