SQL Server Basic SELECT statement

1.SELECT and from statements

Select indicates that the query is executed, and then it needs to know from which side to query the data, from which is the limit of the data being read in which table or tables, which makes up a basic statement.

SELECT * from [table name]

* The function is to select all the columns in the table

　　Some details: Select and from are both uppercase, but not a certain capitalization, used to write uppercase to increase readability, table name variable names can be mixed case, but must be consistent!

Other small examples: in order to speed up the query is best not to use *, but how much data to query how much data!

2.WHERE statements

The where statement is used to set the qualification for returning records.

SQL Server Basic SELECT statement