SQL Server SQL add empty rows

o8x7eapl 于 2023-11-16 发布在其他

关注(0)|答案(1)|浏览(152)

I need to add empty rows to a SQL SELECT statement in such a way that the result is in multiples of 10, meaning if there are 8 rows in a Tables 2 empty Rows should be added so that the select statement has 10 rows and if there are say 16 rows in a Table 4 empty rows should be added so that the select statement has 20 rows etc, etc.

In short at all times the rows selected must be 10,20,30,40, etc, etc.

sql-server

来源：https://stackoverflow.com/questions/47588658/sql-add-empty-rows

1条答案

按热度按时间

5t7ly7z51#

In PostgreSQL something like this should do the job:

select mycol from mytable 
  union all
select null from generate_series(1,round((select count(*)+4 from mytable),-1))

赞(0）回复(0）举报 2023-11-16

我来回答

SQL Server SQL add empty rows

1条答案

相关问题

热门标签

最新问答