Category: T-SQL

NOTES | Getting Started with the SELECT Statement

Using the FROM and SELECT Clauses The FROM and SELECT clauses are two principal clauses that appear in almost every query that retrieves data. When you execute a SELECT statement, it usually retrieves one or more rows of information – the exact number depends on how you construct the statement. These rows are collectively known as a result set. Brief summary of the clauses in a SELECT statement: The FROM Clause FROM – This is the second most important clause in the SELECT statement and is also required. You use the FROM clause to specify the tables or views from… Read More