SQL ²ð·Ö×Ö·û´®
ÓÐtb±í id tags 1 1,2,3 2 1,2 3 1,5,10 4 2,6 5 4,9,15 6 5,8 Èç¹ûÒª¸ù¾Ýtags È¡ÄÚÈÝÏàËÆ¶È×î¸ßµÄǰ5ÌõÊý¾Ý,Ôõôд? ±ÈÈçÎÒµÄÒ»ÌõÊý¾ÝµÄtagsÊÇ'4,9,15' ÄÇÊ×ÏȲéѯ³öÉÏÊöÊý¾ÝÖÐtags='4,9,15' È»ºó²éѯtags°üº¬'4,9'»òÕß'4,15'»òÕß'9,15' ×îºó²éѯ°üº¬'4' »ò '9' »ò '15' µÄ tags×î¶àÓÐ5¸öÊý×Ö×é³É.
×ö¸ö¼ÇºÅ¡£µÈµÈ»ØÀ´¿´ ¡£ ¶î ¸Ð¾õºÃ¸´ÔÓ°¡ ¿ÉÒÔsplit(',') ·Åµ½Ò»¸öÊý×éÖÐ È»ºóÑ»·¶Ô±È ȷʵͦ¸´Ô ¹Ø×¢Ò»Ï »»´æ´¢½á¹¹°É. Òª²»ÄãµÃÏȰÑtb±íÖÐÿÌõÊý¾Ý¸øsplitÁËÔٰѲéѯÊý¾Ýsplit,ÔÙ½øÐи´ÔÓµÄËã·¨²Å¿ÉÒÔ.·Ç³£·±ËöºÍÀË·Ñ×ÊÔ´. Ä㻹²»Èç´æ³É id tags 1 1 1 2 1 3 2 1 2 2 ÕâÑù.ÕâÑùµÄ»°,Ò»¾äsqlÓï¾ä¾ÍÄܸ㶨. select top 5 count(id) as countId where tags in (4,9,15) group by id order by countId ºÃ¾Ã²»Ð´sqlÁË.ûÓÐʵ¼Ê²âÊÔ.˼·ÊÇÕâÑù.Äã×Ô¼º¸Ä¸Ä°É.ÒýÓà »»´æ´¢½á¹¹°É. Òª²»ÄãµÃÏȰÑtb±íÖÐÿÌõÊý¾Ý¸øsplitÁËÔٰѲéѯÊý¾Ýsp
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö ÀýÈç procedure produce_proc @p001 nvarchar(8000), @p002 nvarchar(8000), @p003 nvarchar(8000), & ......
DateTime startTime=DateTime(em_1.Text) DateTime endTime=DateTime(em_2.Text) string sql sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
±íÈçÏ ½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ 101 50 08£º00 08£º30 30 40 50 101 50 09£º00 ......