一个select 查询语句,头晕了
表结构
CREATE TABLE [papers] (
[id] [int] NOT NULL ,
[course] [int] NOT NULL ,
[chapter] [int] NOT NULL ,
[ken] [int] NOT NULL ,
[kind] [int] NOT NULL ,
[content] [varchar] (600) COLLATE Chinese_PRC_BIN NOT NULL ,
[answer] [varchar] (800) COLLATE Chinese_PRC_BIN NOT NULL ,
[difficulty_que] [float] NOT NULL ,
[point] [float] NOT NULL ,
[date] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO
我要在此表中对每一类(kind)随机抽取自己规矩的记录数,并且满足对每一类所设定的条件,抽取的记录总和point为100!
比如:kind(类别)有:1类 ,2类,3类……
我要随机抽取1类里的3条记录满足一定条件,抽取2类2条记录,抽取3类4条记录都要满足一定条件,抽出的这些记录的总分是100