SQL Server Data Query using T-SQL to query data

I. Use T-SQL to query data

 

1. query statement syntax

1.1 query all fields in the table

Select * from Table Name

1.2 query specified fields in the table

Select field name from Table Name

 

2. Basic query statement

2.1 limit the number of queried Columns

Select Field 1, Field 2 from Table Name

2.2 limit the number of queried rows

Select field name from table name where query condition (field = specified value/between value and value/Field in (value 1, value 2 ...))

2.3 use string and alias Functions

Select Field 1 + ''+ Field 2 alias from Table Name

2.4 change the line Order

Select field from table name order by field ASC/DESC

2.5 select non-Repeated Records

Select distinct field from Table Name