sql查询打印所需的输出 [英] sql query to print desired output

问题描述

Hi Team，

我有以下数据

Hi Team,
I have data like below

create table #tmp(id int,name varchar(10))
insert #tmp
select 1, 'a'
union
select 1, 'b'
union
select 1, 'c'
union
select 2, 'a'
union
select 2, 'b'
union
select 2, 'c'
union
select 3, 'a'
union
select 3, 'b'
union
select 3, 'c'

我想要打印数据如下

1 a

2 b

3 c



请帮我这个

先谢谢。

and i want print data like below
1 a
2 b
3 c

please help me on this
Thanks in Advance.

推荐答案

我最好的猜测：

My best guess:

DECLARE @tmp TABLE(id int,name varchar(10))

insert @tmp (id, name)
VALUES( 1, 'a'),
(1, 'b'),
(1, 'c'),
(2, 'a'),
(2, 'b'),
(2, 'c'),
(3, 'a'),
(3, 'b'),
(3, 'c')

SELECT DISTINCT t1.id, t2.name
FROM @tmp AS t1 INNER JOIN
    (
        SELECT id, name, ROW_NUMBER() OVER(PARTITION BY id ORDER BY name) AS RowNo
        FROM @tmp
    ) AS t2 ON t1.id = t2.RowNo

结果 - 正如所料：

Result - as expected:

id  name
1   a
2   b
3   c

这篇关于sql查询打印所需的输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！