真爱无限

摘要： 数据准备：if exists (select * from sysobjects where id = OBJECT_ID('[classinfo]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [classinfo]CREATE TABLE [classinfo] ([id] [bigint] NOT NULL,[classID] [bigint] NOT NULL,[className] [nvarchar] (50) NOT NULL,[stat] [varchar] (2) NOT NUL 阅读全文

摘要： sql查询每个班上成绩最高的学生信息数据库表和数据准备：if exists (select * from sysobjects where id = OBJECT_ID('[classinfo]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [classinfo]CREATE TABLE [classinfo] ([id] [bigint] NOT NULL,[classID] [bigint] NOT NULL,[className] [nvarchar] (50) NOT NULL,[stat 阅读全文