请查看以下内容以了解我想要的内容:
------------------------------
Friend | User
------------------------------
2 | 1
3 | 2
2 | 5
4 | 2
------------------------------
当我搜索值2
时,我希望我的搜索结果返回Friend
和User
格式的相关值,如下所示:
--------------------------
Friends of 2
--------------------------
1 - (from column User )
3 - (from column Friend)
5 - (from column user )
4 = (from column friend )
我想要如下所示的单列搜索结果:
--------------------------
Friends of 2
--------------------------
1
3
5
4
如何在SQL Server中使用SELECT查询来完成此操作?
发布于 2013-07-01 18:32:01
SELECT Friend FROM MyTable WHERE User = 2
UNION
SELECT User FROM MyTable WHERE Friend = 2;
发布于 2013-07-01 18:34:01
select case Friend when 2 then User else Friend end
FROM table
where User = 2
or Friend = 2;
发布于 2013-07-01 18:37:48
Create Table #MyTable(id int identity,FriendID int,UserID int)
Insert into #MyTable values(2,1),(3,2),(2,5),(4,2)
Declare @SearchUserID int=2
select (Case Friendid when @SearchUserID then userID else FriendID end) as [Friends] from #MyTable where @SearchUserID in(Friendid,UserID)
drop Table #MyTable
https://stackoverflow.com/questions/17402280
复制相似问题