22,209
社区成员
发帖
与我相关
我的任务
分享
--创建Demo表
CREATE TABLE [Test] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Source] [numeric](18, 0) NULL
) ON [PRIMARY]
GO
INSERT INTO [test] ([name],[subject],[Source]) values (N'张三',N'语文',60)
INSERT INTO [test] ([name],[subject],[Source]) values (N'李四',N'数学',70)
INSERT INTO [test] ([name],[subject],[Source]) values (N'王五',N'英语',80)
Go
SELECT
(SELECT NAME FROM TB WHERE NAME=N'张三')AS N'张三',
(SELECT NAME FROM TB WHERE NAME=N'李四')AS N'李四',
(SELECT NAME FROM TB WHERE NAME=N'李四')AS N'王五'
UNION ALL
SELECT
(SELECT subject FROM TB WHERE NAME=N'张三')AS N'张三',
(SELECT subject FROM TB WHERE NAME=N'李四')AS N'李四',
(SELECT subject FROM TB WHERE NAME=N'李四')AS N'王五'
UNION ALL
SELECT
(SELECT LTRIM(Source) FROM TB WHERE NAME=N'张三')AS N'张三',
(SELECT LTRIM(Source) FROM TB WHERE NAME=N'李四')AS N'李四',
(SELECT LTRIM(Source) FROM TB WHERE NAME=N'李四')AS N'王五'