我的语句:
SELECT *
FROM Users
where role='卖家'
union
select null,null,null
union下面那个select 我想检索10条null的记录,显示结果如下id name age
1 小李 21
null null null
null null null
null null null
null null null
null null null
null null null
null null null
null null null
null null null
null null null请问,怎么写这个语句???谢谢了!
SELECT *
FROM Users
where role='卖家'
union
select null,null,null
union下面那个select 我想检索10条null的记录,显示结果如下id name age
1 小李 21
null null null
null null null
null null null
null null null
null null null
null null null
null null null
null null null
null null null
null null null请问,怎么写这个语句???谢谢了!
FROM Users
where role='卖家'
union all
select top 10 null,null,null from Users
Users起码要有10条数据
FROM Users
where role='卖家'
union all
select top 10 null,null,null from sysobjects
这个就不管有没有10条记录了
sysobjects中的记录总是超过10条的
select top 1 null,null,null from Users
FROM Users
where role='卖家'
union all
select top 10 null,null,null from sysobjects这个没好使!!!!
FROM Users
where role='卖家'
union all
select top 10 null,null,null from sys.sysobjects
SELECT *
FROM Users
where role='卖家'
union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null union all
select null,null,null
where role='卖家'
union all
select top 10 null,null,null from sys.sysobjects验证通过