SQL Server Get unique values of a column based on another column [closed]

yjghlzjz 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(99)

Closed. This question needs details or clarity . It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post .

Closed 27 days ago.
Improve this question

I'm working on 2 columns(namely Name and Dept). There are multiple values for each value of Name in Dept. There may be other columns than Name and Dept. Could you please help me getting unique values of Name based on Dept?

sql-server

来源：https://stackoverflow.com/questions/76625067/get-unique-values-of-a-column-based-on-another-column

1条答案

按热度按时间

6rvt4ljy1#

select distinct dept, name
from table_name
order by name;

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server Get unique values of a column based on another column [closed]

1条答案

相关问题

热门标签

最新问答