sql查询打印所需的输出

本文介绍了sql查询打印所需的输出的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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