Home > database >  The two query code how to do it is quite urgent, such as online
The two query code how to do it is quite urgent, such as online

Time:11-09

SELECT TOP (1000) (StudentNo)
,
StudentName,, [StudentBirthday]
That [sex]
The FROM [teaching]. [dbo] [Student]
SELECT TOP (1000) (StudentNo)
, [courseNo]
, [score]
The FROM [teaching]. [dbo]. [grade]
SELECT TOP (1000) [courseNo]
, courseName
The FROM [teaching]. [dbo]. [running]
Has the largest number of n 1. Query elective course course number, course name and number of courses, the results in descending order of the number of,
2. Query computer department level 16 students "SQL" course grades, including student id, name, course name, score four columns, the results according to the ascending order of student number, according to

  • Related