C#第九章数据查询基础 练习——查询学生相关基本信息

练习——查询学生相关基本信息

SELECT *FROM dbo.Student
  /*查询第一学期的全部学生信息*/
  SELECT LoginPwd,studentName,Sex,GradeId,Phone,Address,BornDate,Email
  FROM dbo.Student
  WHERE GradeId='6'
  
  /*查询第二学期的全部学生的姓名和电话*/
  SELECT studentName,Phone
  FROM dbo.Student
  WHERE GradeId='7'
  
  /*查询第一学期全部女同学的信息*/
  SELECT  *
  FROM dbo.Student 
  WHERE SEX='女' AND GradeId='6'
  
  /*查询课时超过60的科目信息*/
  SELECT *
  FROM dbo.Subject
  WHERE ClassHour>60
  
  
  SELECT *
  FROM Student
  WHERE studentName