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

ÇóÒ»SQLÓï¾ä - MS-SQL Server / »ù´¡Àà

ÓÐÒ»±íA ÀïÃæÓРѧԺ£¬°à¼¶£¬Ñ§Éú£¬·ÖÊý£¨¹ØÏµÊÇ£ºÑ§ÔºÏÂÃæ°üÀ¨Ê²Ã´°à¼¶Ê²Ã´Ñ§Éú£©

ÒªÇó£ºÖ»ÄÜʹÓÃselectºÍgroup by 


Çó³ö°à¼¶¿¼ÊÔÈËÊý´óÓÚ10 £¬°à¼¶×îµÍ·ÖÔÚ50ÒÔÉÏ£¬¼ÆËãѧԺ£¬°à¼¶Æ½¾ù·Ö´Ó¸ßµ½µÍǰ10Ãû

ÒýÓÃ
ÓÐÒ»±íA ÀïÃæÓРѧԺ£¬°à¼¶£¬Ñ§Éú£¬·ÖÊý£¨¹ØÏµÊÇ£ºÑ§ÔºÏÂÃæ°üÀ¨Ê²Ã´°à¼¶Ê²Ã´Ñ§Éú£©

ÒªÇó£ºÖ»ÄÜʹÓÃselectºÍgroup by


Çó³ö°à¼¶¿¼ÊÔÈËÊý´óÓÚ10 £¬°à¼¶×îµÍ·ÖÔÚ50ÒÔÉÏ£¬¼ÆËãѧԺ£¬°à¼¶Æ½¾ù·Ö´Ó¸ßµ½µÍǰ10Ãû

ÔõôҲµÃÒªtop°É?
ÄѲ»³É°ÑÃû´ÎÈ«²¿Çó³öÀ´,ÔÙ <= 10?


ÒýÓÃ
ÒýÓÃÂ¥Ö÷ jiangjubo µÄ»Ø¸´:
ÓÐÒ»±í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


ÎÒÊÇÀ´Ñ§Ï°µÄ


Ïà¹ØÎÊ´ð£º

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......

asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP

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ͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ