SQL²»Ã÷°× - MS-SQL Server / Ó¦ÓÃʵÀý
²éѯѧÉúƽ¾ù³É¼¨¼°ÆäÃû´Î
SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨)
from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨
from SC
GROUP BY S#
) AS T1
WHERE ƽ¾ù³É¼¨ > T2.ƽ¾ù³É¼¨) as Ãû´Î,
S# as ѧÉúѧºÅ,ƽ¾ù³É¼¨
from (SELECT S#,AVG(score) ƽ¾ù³É¼¨
from SC
GROUP BY S#
) AS T2
ORDER BY ƽ¾ù³É¼¨ desc;
Óï¾ä²»ÊǺÜÀí½â°¡¡£°ïÏÂÎÒ°É
ÓïÑÔ²»Ì«ºÃ±í´ï£¬°ï¶¥°É
SQL code:
--¼ÆËã¾ù·Ö
SELECT S#,AVG(score) ƽ¾ù³É¼¨
from SC
GROUP BY S#
--°´ÕÕѧºÅ¼ÆËãÆ½¾ù·Ö£¬²¢È¡µÃ¸ßÓÚ¾ù·ÖµÄͬѧµÄ¸öÊý
SELECT COUNT( distinct ƽ¾ù³É¼¨)
from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨
from SC
GROUP BY S#
) AS T1
WHERE ƽ¾ù³É¼¨ > T2.ƽ¾ù³É¼¨
--²»¹ý²»ÖªµÀΪºÎ+1£¿
SQL code:
--Ŷ£¬ÕâÑùһĿÁËÈ»ÁË£¬ÆäʵÄã¾ÍÊÇÔÚ¸øÑ§ÉúÅÅÃû´Î¡£
create view view_acg_scor as select s# ѧºÅ,avg(score) ƽ¾ù³É¼¨ from SC group by s#
SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨)
from view_acg_score AS T1
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
id url rank ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......