SQL×ֶΣ¬ºáÏòÕ¹¿ª
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª ÐÕÃû ¿ÆÄ¿ ³É¼¨ ÕÅÈý Ó¢Óï 90 ÀîËÄ Ó¢Óï 85 ÍõÎå Ó¢Óï 80 ÕÅÈý Êýѧ 95 ÀîËÄ Êýѧ 92 ÍõÎå Êýѧ 98 ÕÅÈý ÓïÎÄ 80 ÀîËÄ ÓïÎÄ 85 ÍõÎå ÓïÎÄ 82 ———————————————— ½á¹û ———————————————— ÐÕÃû Ó¢Óï Êýѧ ÓïÎÄ ÕÅÈý 90 95 80 ÀîËÄ 85 92 85 ÍõÎå 80 98 92 ÒýÓà ÐÕÃû ¿ÆÄ¿ ³É¼¨ ÕÅÈý Ó¢Óï 90 ÀîËÄ Ó¢Óï 85 ÍõÎå Ó¢Óï 80 ÕÅÈý Êýѧ 95 ÀîËÄ Êýѧ 92 ÍõÎå Êýѧ 98 ÕÅÈý ÓïÎÄ 80 ÀîËÄ
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
sql2005 select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
PBÖпª·¢µÄ¡£ DateTime startTime=DateTime(em_1.Text) DateTime endTime=DateTime(em_2.Text) string sql sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
Êý¾Ý±í¡¾biao¡¿£¬ ×ֶΣºid¡¢myname¡¢mytxt mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£© ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......