求一个语句实现在查询结果中显示每呢

一个sql语句，实现在查询结果中显示每5行后加一空白行

SQL code

exec(

select 1 as jh, ... pivot

union all

select 2 as jh, ... pivot

union all

select 3 as jh, ... pivot

union all

select 4 as jh, ... pivot

union all

select 5 as jh, ... pivot

)

查询结果为：

1 ...

2 ...

3 ...

4 ...

5 ...

1 ...

2 ...

3 ...

4 ...

5 ...

1 ...

2 ...

3 ...

4 ...

5 ...

......

其中这个查询有30列

用

SQL code

union all

select \'\' as jh ...

30列啊其中还有pivot转化的列

SQL codeCREATE TABLE [TB] (

[ID] [int] IDENTITY (1, 1) NOT NULL ,

[ITEM] [int] NULL ,

[NOTE] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

CONSTRAINT [PK_TB] PRIMARY KEY CLUSTERED

(

[ID]

) ON [PRIMARY]

) ON [PRIMARY]

GO

INSERT INTO TB (ITEM, NOTE) SELECT 3,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 3,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 4,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 5,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 5,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 6,\'XX\'

SELECT * FROM TB

/*-----------------------

3 XX

3 XX

4 XX

5 XX

5 XX

6 XX

*/

SELECT

ITEM=CASE WHEN ID=(

SELECT MIN(ID)

FROM TB

WHERE ITEM=EM

)

THEN RTRIM(ITEM) ELSE \'\' END,

NOTE

FROM TB AS A

ORDER BY ID

/*

ITEM NOTE

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

3 XX

XX

4 XX

5 XX

XX

6 XX

SELECT

ITEM,

NOTE

FROM (

SELECT

RTRIM(ITEM) AS ITEM,NOTE,ITEM AS order1,0 AS order2

FROM TB

UNION ALL

SELECT \'\',\'\',ITEM,1

FROM TB

GROUP BY ITEM

) AS A

ORDER BY order1,order2

3 XX

3 XX

4 XX

5 XX

5 XX

6 XX

SQL codeCREATE TABLE [TB] (

[ID] [int] IDENTITY (1, 1) NOT NULL ,

[ITEM] [int] NULL ,

[NOTE] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

CONSTRAINT [PK_TB] PRIMARY KEY CLUSTERED

(

[ID]

) ON [PRIMARY]

) ON [PRIMARY]

GO

INSERT INTO TB (ITEM, NOTE) SELECT 3,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 3,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 4,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 5,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 5,\'XX\'

INSERT INTO TB (ITEM, NOTE) SELECT 6,\'XX\'

SELECT * FROM TB

/*-----------------------

3 XX

推荐一个检测方法 3 XX

4 XX

5 XX

5 XX

6 XX

*/

SELECT

ITEM=CASE WHEN ID=(

SELECT MIN(ID)

FROM TB

WHERE ITEM=EM

)

THEN RTRIM(ITEM) ELSE \'\' END,

NOTE

FROM TB AS A

ORDER BY ID

/*

ITEM NOTE

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

3 XX

XX

4 XX

5 XX

XX

6 XX

SELECT

ITEM,

NOTE

FROM (

SELECT

RTRIM(ITEM) AS ITEM,NOTE,ITEM AS order1,0 AS order2

FROM TB

UNION ALL

SELECT \'\',\'\',ITEM,1

FROM TB

GROUP BY ITEM

) AS A

ORDER BY order1,order2

3 XX

3 XX

4 XX

5 XX

5 XX

6 XX

艾得辛减量后类风湿会复发吗
上海不孕不育医院治疗费用
重庆治疗妇科