First, the experimental material:
Additional Student Information Form (student)
Second, the experimental requirements:
1. Query the information of all students in the student table
SELECT * FROM Student
2, Query student table "name" "Class" and "Score" column content
Select name, class, score from student
3. Check the names of students in Class 7 in the student table
select name from student WHERE class = ' 7 '
4, Query the student table in the score of 90-100 students all information
SELECT * FROM Student where scores between and
5. Check the information of students who have scored less than 90 points or above 95 points in the student table
SELECT * FROM student where score <90 or score >95
6, query the student table score is 89 points, 90 points of the students all information
SELECT * FROM student where score =89 or score =90
7. Check all information of students surnamed Liu in student table
SELECT * FROM student where name like ' Liu% '
8, inquires the student table in 1 class's name Zhang Hong's student information
SELECT * FROM student where class = ' 1 ' and name = ' Zhang Hong '
9, Query the student table in the note is not empty students all information
SELECT * FROM student where memo is not NULL
10, query the student table in the first 3 rows of data
Select Top 3 * from student
11, Query student table "name" and "Social Security Number" two columns of data, query results "name" column name appears as "name", "id" column name is displayed as "Idcard"
Select name as name, social Security number as Idcard from student
12. Query the total scores of all students in the student table, the column name is displayed as "overall",
Select SUM (Score) as total from student
13. Query All student information in the student table and display the results from high to low according to results
SELECT * FROM student ORDER BY score Desc
14. Check the average scores of all students in the student table
Select AVG (score) as average score from student
15. Check the highest and lowest scores of all students in the student table
Select Max (score) as highest score, Min (score) as Min. from student
16. Query all rows in the student table
Select COUNT (*) Total rows from student
17. Check the total of each class in the student table
Student class, sum (Result) as total score from student group by class
18, query the student table of the total score greater than 181 points of the class
Student in the class, sum (Score) as the total from the student group by the class having a sum (score) >181
19, the student table in 1 classes of student information stored in the table student_1
Student * to AAA from Studentwhere class = ' 1
SQL Server database basic INSERT, delete command