基于参考文档(产品白皮书、手册、测试报告、资质证书等)对招投标技术指标要求进行逐条符合性评估,产出带证据引用的中文 Markdown 评估报告(含四级评定"完全满足/基本满足/部分满足/不满足"、证据出处、每条指标的应答策略建议)。主要面向网络安全产品招投标应答场景,也适用于其他 IT 产品的技术指标符合性评估、采购选型评估、产品能力对照核查等。参考文档支持 docx、pdf、md、xlsx、pptx 等格式(读取时优先调用已安装的专门 skill,如 docx/xlsx/pdf-re
--//创建一个信息表
CREATE TABLE user_student(id decimal(18,0) identity(1,1),st_name nvarchar(30),class nvarchar(10),score decimal(18,2))
--//插入测试数据============start===================
insert into user_student(st_name,class,score)
values('张三','甲','90')
insert into user_student(st_name,class,score)
values('张四','甲','65')
insert into user_student(st_name,class,score)
values('张五','甲','88')
insert into user_student(st_name,class,score)
values('李三','乙','97')
insert into user_student(st_name,class,score)
values('李四','乙','88')
insert into user_student(st_name,class,score)
values('李五','乙','78')
insert into user_student(st_name,class,score)
values('王三','丙','86')
insert into user_student(st_name,class,score)
values('王四','丙','69')
insert into user_student(st_name,class,score)
values('王五','丙','59')
--//插入测试数据============end===================
select * from user_student
--//每个班级分数前两名的学生信息
SELECT ST_NAME,CLASS,SCORE
FROM (
SELECT Row_number() OVER(PARTITION BY CLASS ORDER BY SCORE DESC) AS NUM,*
FROM user_student
) AS T
WHERE NUM
<p>@@##@@</p>










