如何将一行与整个列值匹配 [英] how to match one row with the entire column values

问题描述

我在表格中有以下数据



DepartmentName

IT

软件

技术

技术



如何获得以下格式的数据



DepartmentName Department_Match

IT软件

IT技术

IT技术

i have below data in table Department

DepartmentName
IT
SOFTWARE
TEchnology
Technical

how can i get the data in the below format

DepartmentName Department_Match
IT SOFTWARE
IT TEchnology
IT Technical

推荐答案

很难弄清楚你在这里要做什么 - 以及你为什么要这样做 - 我怀疑你在设计数据库时做出了一些糟糕的选择。但是......

It's difficult to work out what you are trying to do here - and why you are trying to do it - I suspect you have made some poor choices when you designed your DB. But...

SELECT 'IT' AS [Department Name], DepartmentName AS Department_Match FROM Department
WHERE DepartmentName != 'IT'

这篇关于如何将一行与整个列值匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！