A peek at the SQL Select Statement and the basic syntax
An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE) that specify criteria. The syntax is:
SELECT column1, column2, *columns...* FROM table WHERE column2='value';
In the above SQL statement:
The SELECT clause specifies one or more columns to be retrieved; to specify multiple columns, use a comma and a space between column names. To retrieve all columns, use the wild card * (an asterisk).
The FROM clause specifies one or more tables to be queried. Use a comma and space between table names when specifying multiple tables.
The WHERE clause selects only the rows in which the specified column contains the specified value. The value is enclosed in single quotes (for example, WHERE last_name=’Vader’).
The semicolon (;) is the statement terminator. Technically, if you’re sending only one statement to the back end, you don’t need the statement terminator; if you’re sending more than one, you need it. It’s best practice to include it.
Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you.
What you will learn: