ÇósqlÓï¾ä£¬sqliteÊý¾Ý¿â
µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ¶¯¿Í·þ
110 ±¨¾¯
8776532 ÕÅÈý¼Ò
13959112113 ÕÅÈýÊÖ»ú
ÏÖÔڵ绰ºôÈëÆ¥Å乿ÔòΪ£º
Èç¹ûºôÈëºÅÂë>=7λ£¬Æ¥Åäºó7λ£»Èç¹ûºôÈëºÅÂë <7λ£¬È«Æ¥Å䷽ʽ
(»òÕßÉÏÃæ¹æÔò¿ÉÒÔÃèÊöΪ£¬ºôÈëºÅÂëÓëºÅÂë±¾ºÅÂë¶¼´óÓÚµÈÓÚ7λʱ£¬Æ¥Åäºó7λ£»Èç¹ûÈÎÒâÒ»·½Ð¡ÓÚ7λʱ£¬È«Æ¥Å䷽ʽ)
Àý×Ó˵Ã÷Æ¥ÅäÔÔò
¼ÙÈçºôÈë13959112113 ÏÔʾ¡°ÕÅÈýÊÖ»ú¡±
13339112113 ÏÔʾ¡°ÕÅÈýÊÖ»ú¡±
13959112110 ²»ÄÜÆ¥Å䱨¾¯
13959110086 ²»ÄÜÆ¥ÅäÒÆ¶¯¿Í·þ
1008 ÏÔʾ¡°Òƶ¯·þ¡±
13958776532 ÏÔʾ¡°ÕÅÈý¼Ò¡±
8776532 ÏÔʾ¡°ÕÅÈý¼Ò¡±
mark£¬²»´í
SQL code:
select * from numtable where (char_length('ºôÈëºÅÂë')>=7 and char_length(num)>=7 and substring('ºôÈëºÅÂë',char_length('ºôÈëºÅÂë')-6,7)=substring(num,char_length(num)-6,7)) or (char_length('ºôÈëºÅÂë')<7 and num='ºôÈëºÅÂë');
select rel
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL&nb ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......