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