Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql ѧϰ

Ò»¡¢ÈçºÎ´ÓselectµÄ²éѯ½á¹ûÖÐÔÙ´ÎÔËË㣿
µÚÒ»²½£º
´Ö²éѯ¡£Ê×ÏÈÐèÒª½«µÚÒ»²ã²éѯŪ¶Ô£¬¹ØϵŪÇå³þ¡£
select sum(quantity) total ,price_water,price_pollute from pay_water where time_pay >='2010-02-01 00:00:00.000' and time_pay <'2010-02-28 23:59:59.000'
group by price_water,price_pollute
µÚ¶þ²½£º
¶þ´Î²éѯ¡£ÔÚÒ»´Î²éѯµÄ»ù´¡ÉϽøÐÐÔËËã¡£
select total*price_water a ,total*price_pollute b  from (
select sum(quantity) total ,price_water,price_pollute from pay_water where time_pay >='2010-02-01 00:00:00.000' and time_pay <'2010-02-28 23:59:59.000'
group by price_water,price_pollute
) as test
as testÊDZØÐëÓеģ¬Ã»Óоͻᱨ´í¡£
µÚÈý²½£º
ѹËõ£º
select sum(total*price_water) a ,sum(total*price_pollute) b  from (
select sum(quantity) total ,price_water,price_pollute from pay_water where time_pay >='2010-02-01 00:00:00.000' and time_pay <'2010-02-28 23:59:59.000'
group by price_water,price_pollute
) as test
sum()º¯Êý¿ÉÒÔ½«ÉÏÏÂѹËõ£¬Çó³ö¸ÃÁеÄ×ܺ͡£
¶þ¡¢group by Óï¾ä¡£
selectÖеÄ×Ö¶ÎÖ»ÄÜÊÇgroup byÖеÄ×ֶλòÕ߾ۺϺ¯Êý¡£


Ïà¹ØÎĵµ£º

ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄSQL serverÊý¾Ý¿âÖÃÒɳɹ¦ÐÞ¸´

ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄËùÓõÄZmSoft´ÓÒµÌå¼ìÐÅÏ¢ÍøÂçϵͳV2010.1.26 Õýʽ°æ²ÉÓÃSQL SERVER2000ƽ̨,²»Ã÷Ô­Òò,Êý¾Ý¿â"ÖÃÒÉ“,¿Í»§ÊÔ¹ýËùÓÐÍøÉÏ·½·¨,δÄܽâ¾ö.ÉòÑô¿­ÎÄÊý¾Ý»Ö¸´ÖÐÐÄSQLÊý¾Ý¿â¹¤³Ìʦ³É¹¦½«Æä½â¾ö.
ÉòÑô¿­ÎÄÊý¾Ý»Ö¸´ÖÐÐÄMS SQL SERVERÑз¢Ð¡×éÖÂÁ¦ÓÚMsSqlÊý¾Ý¿â¼¼ÊõµÄÑо¿¡£¾­¹ý¶àÄêÑо¿ÍêÈ«ÕÆÎÕÁËS ......

ÓÃwindow batÆô¶¯sql plus²¢Ö´ÐÐsqlÎÄ

ttp.bat
sqlplus user/pwd@TTPPANADB @ttp
ttp.sql
drop user ttpuser cascade;
CREATE USER TTPUSER IDENTIFIED BY e0ttpuser DEFAULT TABLESPACE avcrt001 TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO TTPUSER;
GRANT ALTER SESSION TO TTPUSER;
GRANT CREATE DATABASE LINK TO TTPUSER;
GRANT ......

SQL Server 2005 µ¼ÈëºÍµ¼³öÏòµ¼

SQL Server µ¼ÈëºÍµ¼³öÏòµ¼ÌṩÁËÉú³É Microsoft SQL Server 2005 Integration Services (SSIS) °ü×î¼òµ¥µÄ·½·¨¡£SQL Server µ¼ÈëºÍµ¼³öÏòµ¼¿ÉÒÔ·ÃÎʸ÷ÖÖÊý¾ÝÔ´¡£¿ÉÒÔÏòÏÂÁÐÔ´¸´ÖÆÊý¾Ý»ò´ÓÆäÖи´ÖÆÊý¾Ý£º
·   Microsoft SQL Server
·   ƽÃæÎļþ
·   Microsoft Off ......

SQLÓαê¿ìËÙÉÏÊÖ

ÎÊÌâÃèÊö£ºÓÐÒÔÏÂ2ÕÅ±í£¬
     ±íA
     0_id           0_name      0_Salary
   Y2007001     ´ï¸ç         &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ