SQL查询选了所有课程的学生

Select * from student
where sno in(
select sno from cs
group by sno
having count(*)=(select count(*) from course)
) 

数据库表

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[student]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[student](
 [sno] [numeric](18, 0) NOT NULL,
 [sname] [nchar](10) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[course]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[course](
 [cno] [numeric](18, 0) NOT NULL,
 [cname] [nchar](10) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[cs](
 [cno] [numeric](18, 0) NOT NULL,
 [sno] [numeric](18, 0) NULL
) ON [PRIMARY]
END