ÇóÒ»SQLÓï¾ä
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL 0
µçÊÓ»ú 2000 ´ÙÏú 200 NULL 0
±ùÏä 3000 ´ÙÏú 300 ÀϿͻ§ 400
ÒªµÃ³ö½á¹û
ÉÌÆ· ´òÕÛ·½Ê½ ¼ÛÇ®
±Ê¼Ç±¾ NULL 10000
µçÊÓ»ú ´ÙÏú 2000
µçÊÓ¾ç ´ÙÏú -200
±ùÏä ´ÙÏú 3000
±ùÏä ´ÙÏú -300
±ùÏä ÀϿͻ§ -400
ÐèÇóµÄ±È½ÏÆæ¹Ö¡£
´ó¸ÅÀ´Ëµ£¬Ã¿¸öÓÐЧµÄÕÛ¿Û£¬¶¼ÁíÍâÆðÒ»ÐУ¬²¢Ê¹ÓøºÊý±íʾ
ʵÏÖÆðÀ´±È½ÏÆæ¹Ö£¬¼Ó·Ö
union all
SQL code:
select ÉÌÆ· as ÉÌÆ· ,´òÕÛ·½Ê½1 as ´òÕÛ·½Ê½,Ô¼Û as ¼ÛÇ® from ±í
union all
select ÉÌÆ·,-´òÕÛ·½Ê½1,ÕÛ¿Û1 from ±í
union all
select ÉÌÆ·,-´òÕÛ·½Ê½2,ÕÛ¿Û2 from ±í
union all
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò
ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL
ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ· ......