SQL SERVERÖÐROLLUP ÔËËã·ûµÄÓ÷¨
ÎÊÌâµÄÌá³ö£º
ÏÖÓбíA£¬ÄÚÈÝÈçÏ£º
±àÂë ²Ö¿â ÊýÁ¿
01 A 6
01 B 7
02 A 8
02 B 9
ÏÖÔÚÏë°´±àÂë²éѯ³öÕâÖÖ¸ñʽ:
--------------------
01 A 6
01 B 7
»ã×ÜС¼Æ£º 13
02 A 8
02 B 9
»ã×ÜС¼Æ£º 17
ÎÊ£º¸ÃÈçºÎʵÏÖ£¿
Õ§Ò»¿´£¬ºÃÏñºÜÈÝÒ×£¬ÓÃgroup byºÃÏñÄÜʵÏÖ£¿µ«×ÐϸÑо¿ÏÂÈ¥£¬ÄãÓÖ»á¾õµÃgroup byÒ²ÊÇÎÞÄÜΪÁ¦£¬×ÜǷȱµãʲô£¬ÎÞ´ÓÏÂÊÖ¡£ÄÇô£¬µ½µ×¸ÃÈçºÎ×öÄØ£¿±ð¼±£¬SQL ServerÔç¾Í°ïÎÒÃÇ×öºÃÁË£¬ÏÂÃ棬¸úÎÒÀ´¡£
Ê×ÏÈ£¬ÈÃÎÒÃÇÀ´¿´Ò»¶Î»°£º
ÔÚÉú³É°üº¬Ð¡¼ÆºÍºÏ¼ÆµÄ±¨±íʱ£¬ROLLUP ÔËËã·ûºÜÓÐÓá£ROLLUP ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÀàËÆÓÚ CUBE ÔËËã·ûËùÉú³ÉµÄ½á¹û¼¯¡£
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÊǶàάÊý¾Ý¼¯¡£¶àάÊý¾Ý¼¯ÊÇÊÂʵÊý¾ÝµÄÀ©Õ¹£¬ÊÂʵÊý¾Ý¼´¼Ç¼¸ö±ðʼþµÄÊý¾Ý¡£À©Õ¹½¨Á¢ÔÚÓû§´òËã·ÖÎöµÄÁÐÉÏ¡£ÕâЩÁб»³ÆΪά¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸ö½á¹û¼¯£¬ÆäÖаüº¬Á˸÷ά¶ÈµÄËùÓпÉÄÜ×éºÏµÄ½»²æ±í¸ñ¡£
CUBE ÔËËã·ûÔÚ SELECT Óï¾äµÄ GROUP BY ×Ó¾äÖÐÖ¸¶¨¡£¸ÃÓï¾äµÄÑ¡ÔñÁбíÓ¦°üº¬Î¬¶ÈÁк;ۺϺ¯Êý±í´ïʽ¡£GROUP BY Ó¦Ö¸¶¨Î¬¶ÈÁк͹ؼü×Ö WITH CUBE¡£½á¹û¼¯½«°üº¬Î¬¶ÈÁÐÖи÷ÖµµÄËùÓпÉÄÜ×éºÏ£¬ÒÔ¼°ÓëÕâЩά¶ÈÖµ×éºÏÏàÆ¥ÅäµÄ»ù´¡ÐÐÖеľۺÏÖµ¡£
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
CUBE ºÍ ROLLUP Ö®¼äµÄÇø±ðÔÚÓÚ£º
CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£
ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£
&n
Ïà¹ØÎĵµ£º
1¡¢°´Ê±¼äÅÅÐò
select * from tbl_lms_loginhistory order by loginhistory_logintime desc
2¡¢
ÔÚÒ»¸öÊý¾Ý¿âÖÐÊÇÏÂÁеÄÑù×Ó
³µ´Î Éí·ÝÖ¤ºÅ
27 1
27 2
45 1
25 1
45 2
ÏÖÔÚÎÒÏë »ñµÃµÄÊÇ
³µ´Î ³Ë×ø´ÎÊý
25 1
27 3
45 2
ÇëÎÊ£¬ÎÒµÄSQLÓï¾ä¸ÃÔõôд£¿
select ³µ´ ......
Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......
Ä¿µÄ£ºÍ¨¹ýHTTP·ÃÎÊMS SSAS 2005
ÅäÖ÷½·¨£º
Èç¹ûÏë·ÃÎʶÔÓ¦µÄcube£¬ÔòÐèÖ¸¶¨cubeËùÔڵķþÎñÆ÷Ãû³Æ
ʹ֮¿ÉÒÔͨ¹ýHTTPÐÒé½øÐзÃÎÊ£¬¿ÉÒÔ·µ»ØMDX²éѯËùµÃµ½µÄ½á¹û¼¯ºÍÔªÊý¾Ý
²éѯ½á¹û¼¯µÄ·½·¨ÊÇ£ºExecute()£¬ËüÄܹ»·µ»ØMDXÓï¾äµÄ²éѯ½á¹û
²éѯ½á¹û¼¯ÔªÊý¾Ý·½·¨£ºDiscover()£¬ËüÄܹ»·µ»ØMDXÓï¾äµÄÔªÊý¾ÝÐÅÏ¢¡£¸Ã·½·¨½ÏEx ......
1 ²éѯsqlÓÅ»¯
1.1 Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò£¨Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧORACLE£©
½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí¡£ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí ......
Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......