求一关于时间的SQL语句

upldel 2011-03-28 05:07:36
tb表数据:


商品编号	体积	过帐时间	接收时间

b001	0.10 	2011-3-26 11:54:20	2011-3-26 12:56:10

b002	0.20 	2011-3-26 13:54:12	2011-3-26 13:56:10

b003	0.15 	2011-3-26 13:54:43	2011-3-26 13:56:10

b007	0.75 	2011-3-26 13:54:45	2011-3-26 13:56:10

b007	0.08 	2011-3-26 13:54:48	2011-3-26 13:56:10

b009	0.68 	2011-3-26 13:54:50	2011-3-26 13:56:10

b066	0.38 	2011-3-26 13:54:51	2011-3-26 13:56:10

b044	0.08 	2011-3-26 13:54:53	2011-3-26 13:56:10

b009	1.13 	2011-3-26 13:54:54	2011-3-26 13:56:10

b009	0.38 	2011-3-26 13:54:47	2011-3-26 14:56:10

b009	0.03 	2011-3-26 14:57:27	2011-3-26 15:58:39

b003	0.01 	2011-3-26 15:56:57	2011-3-26 15:58:39

b009	0.02 	2011-3-26 15:57:02	2011-3-26 15:58:39

b007	0.03 	2011-3-26 15:57:04	2011-3-26 15:58:39

b009	0.03 	2011-3-26 15:57:06	2011-3-26 15:58:39

b007	0.03 	2011-3-26 15:57:08	2011-3-26 15:58:39

b009	0.02 	2011-3-26 15:57:10	2011-3-26 15:58:39

b007	0.02 	2011-3-26 15:57:11	2011-3-26 15:58:39

b009	0.64 	2011-3-26 15:57:14	2011-3-26 15:58:39

b007	0.64 	2011-3-26 15:57:16	2011-3-26 15:58:39

b009	0.26 	2011-3-26 15:57:18	2011-3-26 15:58:39

b007	0.38 	2011-3-26 15:57:20	2011-3-26 15:58:39

b009	0.02 	2011-3-26 15:57:21	2011-3-26 15:58:39

b007	0.14 	2011-3-26 15:57:25	2011-3-26 15:58:39

b044	1.57 	2011-3-26 15:57:35	2011-3-26 15:58:39

b066	0.72 	2011-3-26 15:57:35	2011-3-26 15:58:39

b007	0.02 	2011-3-26 19:57:00	2011-3-26 15:58:39

b009	3.92 	2011-3-26 16:23:07	2011-3-26 16:32:01

b009	18.03 	2011-3-26 16:31:34	2011-3-26 16:32:01

b007	8.49 	2011-3-26 20:31:34	2011-3-26 16:32:01

b007	1.80 	2011-3-26 22:23:07	2011-3-26 23:32:01

根据时间"小时"得出下面这种结果


过帐时间	汇总体积

9	

10	

11	0.1

12	

13	3.8172

14	0.03

15	4.526

16	21.9545

17	

18	

19	0.02

20	8.487

21	

22	1.8

23	

接收时间	体积汇总

9	

10	

11	

12	0.1

13	3.4404

14	0.3768

15	4.576

16	30.4415

17	

18	

19	

20	

21	

22	

23	1.8
...全文
232 24 打赏 收藏 转发到动态 举报
写回复
用AI写文章
24 条回复
切换为时间正序
请发表友善的回复…
发表回复
upldel 2011-03-29
  • 打赏
  • 举报
 回复



老师能进来讲解一下吗?
upldel 2011-03-29
  • 打赏
  • 举报
 回复
F姐，你用的是什么版本的数据库，我这里运行的你的，还是错误


服务器: 消息 8120，级别 16，状态 1，行 39

列 'a.过帐时间' 在选择列表中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。




我直接把你的语句放到查询器里查询，提示的．能否远程支持一下．谢谢　　QQ80177251
upldel 2011-03-29
  • 打赏
  • 举报
 回复 


go

select top 15 h=identity(int,9,1) into # from sysobjects

go


老师这句话什么意思！
-晴天 2011-03-28
  • 打赏
  • 举报
 回复 
create table tb([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)

insert tb

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

go

select top 15 h=identity(int,9,1) into # from sysobjects

go

select a.h [过帐时间],isnull(ltrim(sum(b.[体积])),'')[汇总体积]

from # a left join tb b on a.h=datepart(hh,b.[过帐时间])

group by a.h

select a.h [接收时间],isnull(ltrim(sum(b.体积)),'')[汇总体积]

from # a left join tb b on a.h=datepart(hh,b.[接收时间])

group by a.h

go

drop table tb,#

/*

过帐时间        汇总体积

----------- -----------------------------------------

9           

10          

11          0.1000

12          

13          3.8300

14          0.0300

15          4.5300

16          21.9500

17          

18          

19          0.0200

20          8.4900

21          

22          1.8000

23          

警告: 聚合或其他 SET 操作消除了空值。



(15 行受影响)



接收时间        汇总体积

----------- -----------------------------------------

9           

10          

11          

12          0.1000

13          3.4500

14          0.3800

15          4.5800

16          30.4400

17          

18          

19          

20          

21          

22          

23          1.8000

警告: 聚合或其他 SET 操作消除了空值。



(15 行受影响)



*/
qgqch2008 2011-03-28
  • 打赏
  • 举报
 回复 
DECLARE @tb TABLE

    (

      商品编号 VARCHAR(10) ,

      体积 FLOAT ,

      过帐时间 VARCHAR(30) ,

      接收时间 VARCHAR(30)

    )

INSERT  @tb

        SELECT  'b001' ,

                0.10 ,

                '2011-3-26 11:54:20' ,

                '2011-3-26 12:56:10'

        UNION ALL

        SELECT  'b002' ,

                0.20 ,

                '2011-3-26 13:54:12' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b003' ,

                0.15 ,

                '2011-3-26 13:54:43' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b007' ,

                0.75 ,

                '2011-3-26 13:54:45' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b007' ,

                0.08 ,

                '2011-3-26 13:54:48' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b009' ,

                0.68 ,

                '2011-3-26 13:54:50' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b066' ,

                0.38 ,

                '2011-3-26 13:54:51' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b044' ,

                0.08 ,

                '2011-3-26 13:54:53' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b009' ,

                1.13 ,

                '2011-3-26 13:54:54' ,

                '2011-3-26 13:56:10'

        UNION ALL

        SELECT  'b009' ,

                0.38 ,

                '2011-3-26 13:54:47' ,

                '2011-3-26 14:56:10'

        UNION ALL

        SELECT  'b009' ,

                0.03 ,

                '2011-3-26 14:57:27' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b003' ,

                0.01 ,

                '2011-3-26 15:56:57' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                0.02 ,

                '2011-3-26 15:57:02' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.03 ,

                '2011-3-26 15:57:04' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                0.03 ,

                '2011-3-26 15:57:06' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.03 ,

                '2011-3-26 15:57:08' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                0.02 ,

                '2011-3-26 15:57:10' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.02 ,

                '2011-3-26 15:57:11' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                0.64 ,

                '2011-3-26 15:57:14' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.64 ,

                '2011-3-26 15:57:16' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                0.26 ,

                '2011-3-26 15:57:18' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.38 ,

                '2011-3-26 15:57:20' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                0.02 ,

                '2011-3-26 15:57:21' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.14 ,

                '2011-3-26 15:57:25' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b044' ,

                1.57 ,

                '2011-3-26 15:57:35' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b066' ,

                0.72 ,

                '2011-3-26 15:57:35' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b007' ,

                0.02 ,

                '2011-3-26 19:57:00' ,

                '2011-3-26 15:58:39'

        UNION ALL

        SELECT  'b009' ,

                3.92 ,

                '2011-3-26 16:23:07' ,

                '2011-3-26 16:32:01'

        UNION ALL

        SELECT  'b009' ,

                18.03 ,

                '2011-3-26 16:31:34' ,

                '2011-3-26 16:32:01'

        UNION ALL

        SELECT  'b007' ,

                8.49 ,

                '2011-3-26 20:31:34' ,

                '2011-3-26 16:32:01'

        UNION ALL

        SELECT  'b007' ,

                1.80 ,

                '2011-3-26 22:23:07' ,

                '2011-3-26 23:32:01'



--no.1

SELECT  a.row ,

        ISNULL(b.体积, 0) AS 汇总体积

FROM    ( SELECT    row

          FROM      ( SELECT    ROW_NUMBER() OVER ( ORDER BY 商品编号 ) AS row

                      FROM      @tb

                    ) a

          WHERE     a.row BETWEEN 9 AND 23

        ) a

        LEFT JOIN ( SELECT  SUBSTRING(过帐时间, 11, 2) AS 过帐时间 ,

                            SUM(体积) AS 体积

                    FROM    @tb

                    GROUP BY SUBSTRING(过帐时间, 11, 2)

                  ) b ON a.row = b.过帐时间



--no.2

SELECT  a.row ,

        ISNULL(b.体积, 0) AS 体积汇总

FROM    ( SELECT    row

          FROM      ( SELECT    ROW_NUMBER() OVER ( ORDER BY 商品编号 ) AS row

                      FROM      @tb

                    ) a

          WHERE     a.row BETWEEN 9 AND 23

        ) a

        LEFT JOIN ( SELECT  SUBSTRING(接收时间, 11, 2) AS 接收时间 ,

                            SUM(体积) AS 体积

                    FROM    @tb

                    GROUP BY SUBSTRING(接收时间, 11, 2)

                  ) b ON a.row = b.接收时间



row                  汇总体积

-------------------- ----------------------

9                    0

10                   0

11                   0.1

12                   0

13                   3.83

14                   0.03

15                   4.53

16                   21.95

17                   0

18                   0

19                   0.02

20                   8.49

21                   0

22                   1.8

23                   0



(15 行受影响)



row                  体积汇总

-------------------- ----------------------

9                    0

10                   0

11                   0

12                   0.1

13                   3.45

14                   0.38

15                   4.58

16                   30.44

17                   0

18                   0

19                   0

20                   0

21                   0

22                   0

23                   1.8



(15 行受影响)
快溜 2011-03-28
  • 打赏
  • 举报
 回复
[Quote=引用 13 楼 upldel 的回复:]
SQL code

if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)
insert [tb]
select 'b001',0.10,'2011-3-26 1……
[/Quote]

DATEPART(hh,a.接收时间)--这里是a.接收时间
快溜 2011-03-28
  • 打赏
  • 举报
 回复 
select * into #t from (select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23 )t

select

 ltrim(isnull(DATEPART(hh,a.过帐时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'') as 汇总体积

from

 #T  full join tb a

on

 DATEPART(hh,a.过帐时间)=#T.time

group by

 DATEPART(hh,a.过帐时间),#T.time

union all

select '过帐时间','体积汇总'

union all

select

 ltrim(isnull(DATEPART(hh,a.接收时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'')

from

 #T  full join tb a

on

 DATEPART(hh,a.接收时间)=#T.time

group by

 DATEPART(hh,a.接收时间),#T.time
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复 
--我这里怎么是好的 ？

if object_id('[tb]') is not null drop table [tb]

go 

create table [tb]([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)

insert [tb]

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

--------------开始查询--------------------------

---构建时间表

select * into #t from (select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23 )t

select

 ltrim(isnull(DATEPART(hh,a.过帐时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'') as 汇总体积

from

 #T  full join tb a

on

 DATEPART(hh,a.过帐时间)=#T.time

group by

 DATEPART(hh,a.过帐时间),#T.time

union all

select '过帐时间','体积汇总'

union all

select

 ltrim(isnull(DATEPART(hh,a.接收时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'')

from

 #T  full join tb a

on

 DATEPART(hh,a.接收时间)=#T.time

group by

 DATEPART(hh,接收时间),#T.time





drop table #t



/*

(31 行受影响)



(15 行受影响)

过帐时间         汇总体积

------------ -----------------------------------------

9            

10           

11           0.1000

12           

13           3.8300

14           0.0300

15           4.5300

16           21.9500

17           

18           

19           0.0200

20           8.4900

21           

22           1.8000

23           

过帐时间         体积汇总

9            

10           

11           

12           0.1000

13           3.4500

14           0.3800

15           4.5800

16           30.4400

17           

18           

19           

20           

21           

22           

23           1.8000

警告: 聚合或其他 SET 操作消除了 Null 值。



(31 行受影响)



*/
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复 
if object_id('[tb]') is not null drop table [tb]

go 

create table [tb]([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)

insert [tb]

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

--------------开始查询--------------------------

---构建时间表

select * into #t from (select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23 )t

select

 ltrim(isnull(DATEPART(hh,a.过帐时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'') as 汇总体积

from

 #T  full join tb a

on

 DATEPART(hh,a.过帐时间)=#T.time

group by

 DATEPART(hh,过帐时间),#T.time

union all

select '过帐时间','体积汇总'

union all

select

 ltrim(isnull(DATEPART(hh,a.接收时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'')

from

 #T  full join tb a

on

 DATEPART(hh,a.接收时间)=#T.time

group by

 DATEPART(hh,接收时间),#T.time





drop table #t



/*

(31 行受影响)



(15 行受影响)

过帐时间         汇总体积

------------ -----------------------------------------

9            

10           

11           0.1000

12           

13           3.8300

14           0.0300

15           4.5300

16           21.9500

17           

18           

19           0.0200

20           8.4900

21           

22           1.8000

23           

过帐时间         体积汇总

9            

10           

11           

12           0.1000

13           3.4500

14           0.3800

15           4.5800

16           30.4400

17           

18           

19           

20           

21           

22           

23           1.8000

警告: 聚合或其他 SET 操作消除了 Null 值。



(31 行受影响)



*/
upldel 2011-03-28
  • 打赏
  • 举报
 回复 


if object_id('[tb]') is not null drop table [tb]

go 

create table [tb]([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)

insert [tb]

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

--------------开始查询--------------------------

---构建时间表

select * into #t from (select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23 )t

select

 ltrim(isnull(DATEPART(hh,a.过帐时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'') as 汇总体积

from

 #T  full join tb a

on

 DATEPART(hh,a.过帐时间)=#T.time

group by

 DATEPART(hh,过帐时间),#T.time

union all

select '过帐时间','体积汇总'

union all

select

 ltrim(isnull(DATEPART(hh,a.接收时间),#T.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'')

from

 #T  full join tb a

on

 DATEPART(hh,a.接收时间)=#T.time

group by

 DATEPART(hh,接收时间),#T.time

这样改了之后提示


服务器: 消息 8120，级别 16，状态 1，行 39

列 'a.过帐时间' 在选择列表中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复
里面的f换成#T就可以了
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复
[Quote=引用 9 楼 upldel 的回复:]
SQL code

服务器: 消息 156，级别 15，状态 1，行 36
在关键字 'with' 附近有语法错误。



提示有错误
[/Quote]
那是我构建的一个时间表 

--2000改成



select * into #t from (select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23 )t
upldel 2011-03-28
  • 打赏
  • 举报
 回复
我用得是sql2000
upldel 2011-03-28
  • 打赏
  • 举报
 回复 


服务器: 消息 156，级别 15，状态 1，行 36

在关键字 'with' 附近有语法错误。


提示有错误
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复 
----------------------------------------------------------------

-- Author  :fredrickhu(小F，向高手学习)

-- Date    :2011-03-28 17:11:27

-- Verstion:

--      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) 

--	Jul  9 2008 14:43:34 

--	Copyright (c) 1988-2008 Microsoft Corporation

--	Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

--

----------------------------------------------------------------

--> 测试数据：[tb]

if object_id('[tb]') is not null drop table [tb]

go 

create table [tb]([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)

insert [tb]

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

--------------开始查询--------------------------

---构建时间表

;with f as 

(select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23

)

select

 ltrim(isnull(DATEPART(hh,a.过帐时间),f.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'') as 汇总体积

from

 f  full join tb a

on

 DATEPART(hh,a.过帐时间)=f.time

group by

 DATEPART(hh,过帐时间),f.time

union all

select '过帐时间','体积汇总'

union all

select

 ltrim(isnull(DATEPART(hh,a.接收时间),f.time)) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'')

from

 f  full join tb a

on

 DATEPART(hh,a.接收时间)=f.time

group by

 DATEPART(hh,接收时间),f.time

----------------结果----------------------------

/* 

过帐时间         汇总体积

------------ -----------------------------------------

9            

10           

11           0.1000

12           

13           3.8300

14           0.0300

15           4.5300

16           21.9500

17           

18           

19           0.0200

20           8.4900

21           

22           1.8000

23           

过帐时间         体积汇总

9            

10           

11           

12           0.1000

13           3.4500

14           0.3800

15           4.5800

16           30.4400

17           

18           

19           

20           

21           

22           

23           1.8000

警告: 聚合或其他 SET 操作消除了 Null 值。



(31 行受影响)



*/
upldel 2011-03-28
  • 打赏
  • 举报
 回复
[Quote=引用 4 楼 fredrickhu 的回复:]
SQL code
----------------------------------------------------------------
-- Author :fredrickhu(小F，向高手学习)
-- Date :2011-03-28 17:11:27
-- Verstion:
-- Microsoft SQL Server 2008 (RTM) - 1……
[/Quote]

fredrickhu你的这个结果是对的,我想把两个结果块得出来怎么写啊!
dawugui 2011-03-28
  • 打赏
  • 举报
 回复
[Quote=引用 5 楼 addfox 的回复:]
引用 3 楼 fredrickhu 的回复:
SQL code
----------------------------------------------------------------
-- Author :fredrickhu(小F，向高手学习)
-- Date :2011-03-28 17:11:27
-- Verstion:
-- Microsoft SQL Server……
[/Quote]union all
addfox 2011-03-28
  • 打赏
  • 举报
 回复
[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code
----------------------------------------------------------------
-- Author :fredrickhu(小F，向高手学习)
-- Date :2011-03-28 17:11:27
-- Verstion:
-- Microsoft SQL Server 2008 (RTM) - 1……
[/Quote]
F姐,这两个结果能不能一起得出来啊!
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复 
----------------------------------------------------------------

-- Author  :fredrickhu(小F，向高手学习)

-- Date    :2011-03-28 17:11:27

-- Verstion:

--      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) 

--	Jul  9 2008 14:43:34 

--	Copyright (c) 1988-2008 Microsoft Corporation

--	Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

--

----------------------------------------------------------------

--> 测试数据：[tb]

if object_id('[tb]') is not null drop table [tb]

go 

create table [tb]([商品编号] varchar(4),[体积] numeric(18,4),[过帐时间] datetime,[接收时间] datetime)

insert [tb]

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

--------------开始查询--------------------------

---构建时间表

;with f as 

(select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23

)

select

 isnull(DATEPART(hh,a.过帐时间),f.time) as 过帐时间,

 ISNULL(ltrim(sum(体积)),'')

from

 f  full join tb a

on

 DATEPART(hh,a.过帐时间)=f.time

group by

 DATEPART(hh,过帐时间),f.time

----------------结果----------------------------

/* 



(31 行受影响)

过帐时间        

----------- -----------------------------------------

9           

10          

11          0.1000

12          

13          3.8300

14          0.0300

15          4.5300

16          21.9500

17          

18          

19          0.0200

20          8.4900

21          

22          1.8000

23          

警告: 聚合或其他 SET 操作消除了 Null 值。



(15 行受影响)





*/
--小F-- 2011-03-28
  • 打赏
  • 举报
 回复 
----------------------------------------------------------------

-- Author  :fredrickhu(小F，向高手学习)

-- Date    :2011-03-28 17:11:27

-- Verstion:

--      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) 

--	Jul  9 2008 14:43:34 

--	Copyright (c) 1988-2008 Microsoft Corporation

--	Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

--

----------------------------------------------------------------

--> 测试数据：[tb]

if object_id('[tb]') is not null drop table [tb]

go 

create table [tb]([商品编号] varchar(4),[体积] numeric(4,2),[过帐时间] datetime,[接收时间] datetime)

insert [tb]

select 'b001',0.10,'2011-3-26 11:54:20','2011-3-26 12:56:10' union all

select 'b002',0.20,'2011-3-26 13:54:12','2011-3-26 13:56:10' union all

select 'b003',0.15,'2011-3-26 13:54:43','2011-3-26 13:56:10' union all

select 'b007',0.75,'2011-3-26 13:54:45','2011-3-26 13:56:10' union all

select 'b007',0.08,'2011-3-26 13:54:48','2011-3-26 13:56:10' union all

select 'b009',0.68,'2011-3-26 13:54:50','2011-3-26 13:56:10' union all

select 'b066',0.38,'2011-3-26 13:54:51','2011-3-26 13:56:10' union all

select 'b044',0.08,'2011-3-26 13:54:53','2011-3-26 13:56:10' union all

select 'b009',1.13,'2011-3-26 13:54:54','2011-3-26 13:56:10' union all

select 'b009',0.38,'2011-3-26 13:54:47','2011-3-26 14:56:10' union all

select 'b009',0.03,'2011-3-26 14:57:27','2011-3-26 15:58:39' union all

select 'b003',0.01,'2011-3-26 15:56:57','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:02','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:04','2011-3-26 15:58:39' union all

select 'b009',0.03,'2011-3-26 15:57:06','2011-3-26 15:58:39' union all

select 'b007',0.03,'2011-3-26 15:57:08','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:10','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 15:57:11','2011-3-26 15:58:39' union all

select 'b009',0.64,'2011-3-26 15:57:14','2011-3-26 15:58:39' union all

select 'b007',0.64,'2011-3-26 15:57:16','2011-3-26 15:58:39' union all

select 'b009',0.26,'2011-3-26 15:57:18','2011-3-26 15:58:39' union all

select 'b007',0.38,'2011-3-26 15:57:20','2011-3-26 15:58:39' union all

select 'b009',0.02,'2011-3-26 15:57:21','2011-3-26 15:58:39' union all

select 'b007',0.14,'2011-3-26 15:57:25','2011-3-26 15:58:39' union all

select 'b044',1.57,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b066',0.72,'2011-3-26 15:57:35','2011-3-26 15:58:39' union all

select 'b007',0.02,'2011-3-26 19:57:00','2011-3-26 15:58:39' union all

select 'b009',3.92,'2011-3-26 16:23:07','2011-3-26 16:32:01' union all

select 'b009',18.03,'2011-3-26 16:31:34','2011-3-26 16:32:01' union all

select 'b007',8.49,'2011-3-26 20:31:34','2011-3-26 16:32:01' union all

select 'b007',1.80,'2011-3-26 22:23:07','2011-3-26 23:32:01'

--------------开始查询--------------------------

---构建时间表

;with f as 

(select 9 as time union all select 10 union all select 11 union all select 12 union all select 13 union all 

select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all 

select 19 union all select 20 union all select 21 union all select 22 union all select 23

)

select

 isnull(DATEPART(hh,a.过帐时间),f.time) as 过帐时间,

 ISNULL(sum(体积),0)

from

 f  full join tb a

on

 DATEPART(hh,a.过帐时间)=f.time

group by

 DATEPART(hh,过帐时间),f.time

----------------结果----------------------------

/* 

(31 行受影响)

过帐时间        

----------- ---------------------------------------

9           0.00

10          0.00

11          0.10

12          0.00

13          3.83

14          0.03

15          4.53

16          21.95

17          0.00

18          0.00

19          0.02

20          8.49

21          0.00

22          1.80

23          0.00

警告: 聚合或其他 SET 操作消除了 Null 值。



(15 行受影响)





*/
加载更多回复（2）
SQLServer_2000-2008_R2查询智能分析器RedGate_SQL_Prompt_V5.3.4.1_Crack_Keygen破解教程注册机免费
SQL脚本越写越多，总是觉得编写效率太过于低下，这和打字速度无关。在我个人编写SQL脚本时，至少会把SQL的格式排列成易于阅读的，因为其他人会阅读到你的SQL，无论是在程序中或是脚本文件中，良好的排版不仅让人看起来赏心悦目，在和他人之间做交流时也省时省力，不会因为揉成一团的sql去询问Team Member：您能帮我解释一下这么一大段sql是做什么的吗？ 虽然微软至SQL 2008以上的版本提供了SQL智能提示，但是它的反应实在是过于迟钝，等提示出来我们早就可以敲出一行语句了。而且它没有提供sql代码格式化的功能，咱们只能自己做手动格式化，手动格式化sql总是需要花费不少时间的。 它也是一款拥有智能提示的sql编程工具，而且小巧灵活。 总而言之，它也是一款能够提高sql编程效率的工具。 注释：内附破解教程doc。和keygen，欢迎免费下载
数据库SQL基本语句（半天即可学会，轻松简单）
只要你花半天时间，就能轻松掌握SQL基本语句的使用方式，很好的参考资料，主要看文章中的例子，因为例子具有可读连续性，因此，文档描述非常简单，容易掌握，也较通俗易懂！与大家分享！与大家共享！
数据库面试SQL编写题目精讲
    数据库管理员（Database Administrator，简称DBA），是从事管理和维护数据库管理系统(DBMS)的相关工作人员的统称，属于运维工程师的一个分支，主要负责业务数据库从设计、测试到部署交付的全生命周期管理。DBA的核心目标是保证数据库管理系统的稳定性、安全性、完整性和高性能。    SQL (Structured Query Language) 是具有数据操纵和数据定义等多种功能的数据库语言，这种语言具有交互性特点，能为用户提供极大的便利，数据库管理系统应充分利用SQL语言提高计算机应用系统的工作质量与效率。     SQL编写是各大企业面试DBA工程师考的题目！提现了数据库工程师的基本功，成为了面试的验金石！通过本课程的学习，会让您在规定的时间掌握SQL语句的编写技巧，从容应对考试！ 
sql语句的时间比较(时间段查询) ---- 记录
SQL相关 sql语句的时间比较(时间段查询) ---- 记录 sql语句的时间比较(时间段查询) ---- 记录 不管是mysql，还是sqlserver的sql语句如果直接使用 ： create_time >= '2021-06-16' and create_time <= '2021-06-16' 查询的时候，都会自动补全时间，实际查询sql语句为： create_time >= '2021-06-16 00:00:00' and create_time <= '2
sql语句 求一段时间内的统计
已经有好久没写sql语句了，好多语法都忘记了，今天要写一个求一段时间内数据的统计，遇到了一丢丢小麻烦。低级错误，把正确的语法写出来，以备以后再忘记了。&lt;select id="childbirthSummary" parameterType="map" resultType="map"&gt; SELECT SUM(id) nest_number, SUM(...
疑难问题

22,210

社区成员

121,726

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章