ÇóÒ»SQLÓï¾ä - MS-SQL Server / »ù´¡Àà
ÓÐÒ»±íA ÀïÃæÓРѧԺ£¬°à¼¶£¬Ñ§Éú£¬·ÖÊý£¨¹ØÏµÊÇ£ºÑ§ÔºÏÂÃæ°üÀ¨Ê²Ã´°à¼¶Ê²Ã´Ñ§Éú£©
ÒªÇó£ºÖ»ÄÜʹÓÃselectºÍgroup by
Çó³ö°à¼¶¿¼ÊÔÈËÊý´óÓÚ10 £¬°à¼¶×îµÍ·ÖÔÚ50ÒÔÉÏ£¬¼ÆËãѧԺ£¬°à¼¶Æ½¾ù·Ö´Ó¸ßµ½µÍǰ10Ãû
ÔõôҲµÃÒªtop°É?
ÄѲ»³É°ÑÃû´ÎÈ«²¿Çó³öÀ´,ÔÙ <= 10?
TOPÊÇ¿ÉÒÔʹÓÃ
PS:Õâ¸öÊÇÎÒÔÚÃæÊÔµÄÎÊÌâ!
ÊÇ×ܵÄǰʮÃû£¿»¹ÊÇÿ¸öѧԺ£¬Ã¿¸ö°à¼¶µÄǰʮÃû£¿
SQL code:
×îºÃ¸ø³öÍêÕûµÄ±í½á¹¹,²âÊÔÊý¾Ý,¼ÆËã·½·¨ºÍÕýÈ·½á¹û.
·¢Ìû×¢ÒâÊÂÏî
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
ÎÒÊÇÀ´Ñ§Ï°µÄ
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......