6.SQL Server SQL statements

1.Select Query

SELECT * from users queries the user table for all information

Select Name,age as age from users Where name= ' Zhangsan ' and age=10 increase query conditions

Select A to UserInfo results insert into a new table

Select name from the users order by age desc, Num desc sort desc Descending asc Ascending

GROUP BY group query AVG (column name) average Coung () Total row

Group queries based on different employee categories how many people belong to different employee classes

Select COUNT (*) as total, employee category from the Users group by employee category

Group by has two keywords cube and rollup

2.Select function

6.SQL Server SQL statements