在SQL中的下一行中移位行 [英] Shift Row in Next Row in SQL

问题描述

大家好，



我有一张桌子 -

Hello All,

I have a table like -

          Name          Mobile
1        Sachin        8010023456
2        Kamal         9935463456

我们必须像以下一样返回 -

We have to return just like as -

          Name       Mobile
1         Blank      Blank
2        Sachin     8010023456
3        Kamal      9935463456

推荐答案

请阅读我的评论。



我不确定你想达到什么，但看看示例：

Please, read my comment.

I'm not sure what you want to achieve, but have a look at example:

SELECT NULL AS [Name], NULL AS [Mobile]
UNION ALL
SELECT [Name], [Mobile]
FROM TableName

如果您只想将第一条记录输出为空白，请尝试此操作。将@t替换为您的表名。

If you just want a output with 1st record as blank try this. Replace @t with your table name.

select ROW_NUMBER()over(order by name), name,phone
 from (
 select '' as name,'' as phone
 union all
 select  name,phone from @t
 ) p

你应该从表中查询并复制到另一个表并将其命名为

you should query from table and copy to another table and raname it

这篇关于在SQL中的下一行中移位行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！