SQL ------------------- 数据查询基础_sql第九章数据查询基础简答-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_36024620/article/details/53288904

本文提供了一系列SQL查询示例，展示了如何从学校数据库中筛选特定条件的学生信息，包括按年级、性别及出生日期等条件进行筛选的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [StudentNo]
      ,[LoginPwd]
      ,[StudentName]
      ,[Sex]
      ,[GradeId]
      ,[Phone]
      ,[Address]
      ,[BornDate]
      ,[Email]
  FROM [MySchool].[dbo].[Student]
  SELECT StudentNo, LoginPwd, StudentName, Sex, GradeId, Phone, Address, BornDate, Email
  FROM Student
  WHERE GradeId=1
  
  SELECT StudentName, Phone,GradeId
  FROM Student
  WHERE GradeId=2
  
    
  SELECT  StudentNo, LoginPwd, StudentName, Sex, GradeId, Phone, Address, BornDate, Email
  FROM Student
  WHERE GradeId=1 AND Sex='女'
  
      
  SELECT SubjectId, SubjectName, ClassHour, GradeId
  FROM [Subject]
  WHERE ClassHour>60
  
  
  SELECT SubjectName
  FROM [Subject]
  WHERE GradeId=1
  
     
  SELECT StudentName, Sex,  [Address]
  FROM Student
  WHERE GradeId=2 AND Sex='男'
  
       
  SELECT StudentName, GradeId
  FROM Student
  WHERE  Email IS NULL
  
  
       
  SELECT StudentName,BornDate
  FROM Student
  WHERE GradeId=2 AND BornDate>1990
  
         
  SELECT StudentName,BornDate
  FROM Student
  WHERE GradeId=2 AND BornDate>1990
  
  SELECT *
  FROM dbo.Result
  WHERE SubjectId=1 AND ExamDate='2013-2-15'
  
   SELECT StudentNo, LoginPwd, StudentName, Sex, GradeId, Phone, Address, BornDate, Email
  FROM Student
  WHERE GradeId=1
  ORDER BY BornDate
  
  
   SELECT Id, StudentNo, SubjectId, StudentResult, ExamDate
  FROM dbo.Result
  WHERE SubjectId=1
  ORDER BY ExamDate ASC ,StudentResult DESC
  
  SELECT TOP 5 StudentResult
   FROM [Subject], dbo.Result
  WHERE SubjectName='面向对象程序设计' AND ExamDate='2013/3/22'
  
  
     SELECT TOP 1 SubjectName
  FROM dbo.Subject
  WHERE GradeId=3 
   ORDER BY  ClassHour DESC
   
   
   SELECT StudentName,GradeId
  FROM dbo.Student
  ORDER BY BornDate ASC
  
  
    SELECT StudentResult,SubjectName
   FROM [Subject], dbo.Result
  WHERE ExamDate='2013/3/22'
  ORDER BY StudentResult ASC
  
    SELECT Id, StudentNo, SubjectId, StudentResult, ExamDate
   FROM dbo.Result
  WHERE StudentNo='S1101003'
  ORDER BY ExamDate ASC