Sql²éѯÓï¾äÎÊÌâ - .NET¼¼Êõ / ASP.NET
±ít1
3¸ö×Ö¶ÎCompanyName Product EntryDate
°´ÕÕʱ¼äÅÅÐòÏÔʾǰ10ÌõÊý¾Ý¡£
µ«ÊÇ£¬Ã¿Ò»¼Ó¹«Ë¾ËùÏÔʾµÄ²úÆ·¼Ç¼²»Äܳ¬¹ý2Ìõ¡£
Ò²¾ÍÊÇ˵£¬ÓпÉÄÜÇ°Ãæ10ÌõÊý¾Ý¶¼ÊÇͬһ¼Ò¹«Ë¾µÄ¡£ÄDz»ÐУ¬±ØÐëÒ»¼Ó¹«Ë¾¡£×î¶àÖ»ÄÜ2Ìõ¡£
ÕâÊÇÎÒÃæÊÔÅöµ½µÄÒ»¸öÎÊÌâ¡£¿àÏëÁ˺ܾã¬Ò²Î´ÄÜÍ»ÆÆ¡£»¹Çë¸ßÊÖÃÇÖ¸½Ì¡£Ð»Ð»£¡
Çó¸ßÊÖ£¬×Ô¼º¶¥
Ò²¾ÍÊÇ˵ֻÏÔʾ5¼Ò¹«Ë¾ £¿ ¶øÇÒÊÇ5¼Ò¹«Ë¾ÀïµÄÐÅÏ¢×î¿¿Ç°µÄ2ÌõÊý¾Ý £¿£¿
Èç¹ûÊÇsql server 2005ÒÔÉÏ£¬¿ÉÒÔÓÃrank():
select top 10 t.CompanyName, t.Product, t.EntryDate
from (select CompanyName, Product, EntryDate , rank() as rank over (partition by CompanyName order by entrydate) from t1 order by entrydate) t where t.rank <= 2
ÓеãÄѶÈ~~~
select * from Tb a where CompanyName in (select top 2 CompanyName from Tb where id=a.id order by CompanyName)
ÓеãÂé·³!
Èç¹ûÊÇsql server 2000,ÊÔÊÔÕâ¸ö£º
select top 10 a.* from t1 a where (select count(*) from t1 b where a.CompanyName = b.CompanyName and a.EntryDate < b.EntryDate) <= 2
¸Äһϣº
select top 10 a.* from t1 a where (select count(*) from t1 b where a.CompanyName = b.CompanyName and a.EntryDate < b.EntryDate) <= 2 order by a.entrydate
ºÏÔÚÒ»Æð£º
sql server 2005ÒÔÉÏ£º
SQL code:
select top 10 t.CompanyName, t.Product, t.EntryDate
from (selec
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøվͼƬ¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......