sql server ¹ØÓÚ Êý¾Ý»ã×Ü·ÖÎö
CUBE ºÍ ROLLUP Ö®¼äµÄÇø±ðÔÚÓÚ£º
CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£
ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£
Àý×Ó£º
if object_id('a') is not null
drop table a
create table a
(
bm varchar(20), --±àÂë
ck varchar(2), --²Ö¿â
sl int --ÊýÁ¿
)
insert into a
select '01' ,'a', 6
union all
select '01','b',7
union all
select '02','a',8
union all
select '02','b',9
select * from a
£¨1£©rollup µÄÓ÷¨
SELECT bm, hj=
case when grouping(ck)=0
then
ck
else
bm+'ºÏ¼Æ'
end
, Sum(sl) as sl
from A
GROUP BY bm, ck WITH ROLLUP
/*
01 a 6
01 b 7
01 01ºÏ¼Æ 13
02 a 8
02 b 9
02 02ºÏ¼Æ 17
NULL NULL 30
*/
£¨2£©¹ØÓÚcubleµÄ»ù±¾Ó÷¨¡£
SELECT bm, ck, Sum(sl) as sl
from A
GROUP BY bm,ck WITH cube
/*
01 a 6
01 b 7
01 NULL
Ïà¹ØÎĵµ£º
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
USE [rossic]
GO
/****** Object: StoredProcedure [dbo].[fn_GetLunar] Script Date: 02/23/2010 15:46:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[fn_GetLunar]   ......
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), GETDATE(), 4): 16.05.06
SELECT CONVERT(varch ......
MySQL
ÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£SQL£¨½á¹¹»¯²éѯÓïÑÔ£©ÊÇÊÀ½çÉÏ×îÁ÷Ðеĺͱê×¼»¯µÄÊý¾Ý¿âÓïÑÔ¡£MySQL
ÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqld
ºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£
SQLÊÇÒ»ÖÖ±ê×¼»¯µÄÓïÑÔ£¬ËüʹµÃ´æ´¢¡¢¸üкʹæÈ¡ÐÅÏ¢¸üÈÝÒס£ÀýÈ磬ÄãÄÜÓÃSQLÓïÑÔΪһ¸öÍøÕ¾¼ìË ......
if object_id('tb') is not null drop table tb
go
create table tb([A] varchar(10),[B] int)
insert tb
select 'bcd',1 union all
select 'bcde',2 union all
select 'cd',3
go
¸öÈË·ÖÎöÕâµÀÌâµÄ˼·ÊÇ£º
ͨ¹ýSubstring() À´Ñ»··Ö¸î B ÁÐϵÄ×Ö·û´®¡£¡£
--ÏëµÃµ½µÄ½á¹û£º
/**
a b& ......