Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»SQLд·¨ - MS-SQL Server / »ù´¡Àà

id                           url                   rank     ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ