求助！SQL查询编程！！！ - 编程论坛

#2

uubird2009-11-23 20:32

BEGIN
    DECLARE @s int
    BEGIN
        SELECT @s=COUNT(*) FROM book
    END
    BEGIN
        SELECT press AS '出版社',
           case
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >50 then '很高'
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >=30 then '较高'
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >=10 then '一般'
             else '较低'
             end
         AS '出版社的图书百分比'
                    FROM book
GROUP  BY press
    END
END

#3

gubin1232009-11-24 18:46

BEGIN
    DECLARE @s int
    BEGIN
        SELECT @s=COUNT(*) FROM book
    END
    BEGIN
        SELECT press AS '出版社',
           case
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >50 then '很高'
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >=30 then '较高'
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >=10 then '一般'
             else '较低'
             end
         AS '出版社的图书百分比'
                    FROM book
GROUP  BY press
    END
END

#4

gubin1232009-11-24 18:51

BEGIN
    DECLARE @s int
    BEGIN
        SELECT @s=COUNT(*) FROM book
    END
    BEGIN
        SELECT press AS '出版社',
           case
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >50 then '很高'
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >=30 then '较高'
             when CAST(ROUND(COUNT(*)*1.0*100/@s,1) AS DECIMAL(3,1)) >=10 then '一般'
             else '较低'
             end
         AS '出版社的图书百分比'
                    FROM book
GROUP  BY press
    END
END

#5

uubird2009-11-24 19:48

回复 4楼 gubin123

老兄，怎么复制我的两遍是什么意思啊？

是不是我那里错了