sql问题相关联合查询。 [英] sql Problem related union query.

问题描述

 //我的 union 首先查询
 选择 b.UserId，b.UserName 来自用户b 其中 b.UserId = '  e47277ab-5c62-4311-80f9-b5705fd075f6' 
 
  union  
 //我的 union  secode查询
 选择 a。 userId，a.UserName + '   - ' + a.FirstName + a.LastName  As  UserName 来自用户a 
 其中​​ a.ParentUserId = '  e47277ab-5c62-4311-80f9-b5705fd075f6' 

当我运行这些查询时，我希望首先获得FirstQuery数据，并获得Secode查询数据在第一次查询后。数据。你有任何解决办法。

解决方案

你好，



这样的事情应该有所帮助。



... SQL未经测试，但它应该可以让你大部分时间。

  SELECT  
 t.UserId 
，t.UserName 
  FROM  
（
   -   我的联合第一次查询 
 选择  1   AS  OrderColumn，b.UserId，b.UserName 来自用户b 其中​​ b。 UserId = '  e47277ab-5c62-4311-80f9-b5705fd075f6' 
  union  
   -    my union secode query  
 选择  2   AS  OrderColumn，a.userId，a.UserName + '   - ' + a.FirstName + a.LastName < span class =code-keyword>作为用户名来自用户a 
 其中 a.ParentUserId = '  e47277ab-5c62-4311-80f9-b5705fd075f6' 
）< span class =code-keyword> AS  t 
  ORDER   BY  
 t.OrderColumn 
; 

//my union first query
select b.UserId,b.UserName from Users b where b.UserId='e47277ab-5c62-4311-80f9-b5705fd075f6'

union
//my union secode query
select a.userId,a.UserName + '-' + a.FirstName + a.LastName As UserName from Users a
where a.ParentUserId='e47277ab-5c62-4311-80f9-b5705fd075f6'

When i run these query i want to get FirstQuery Data come first and Secode Query Data come after First query. data. do u have any solution for that.

解决方案

Hi,

Something like this should help.

... the SQL is untested, but it should get you most of the way there.

SELECT 
 t.UserId
,t.UserName
FROM
(
--my union first query
select 1 AS OrderColumn, b.UserId,b.UserName from Users b where b.UserId='e47277ab-5c62-4311-80f9-b5705fd075f6'
union
--my union secode query
select 2 AS OrderColumn, a.userId,a.UserName + '-' + a.FirstName + a.LastName As UserName from Users a
where a.ParentUserId='e47277ab-5c62-4311-80f9-b5705fd075f6'
) AS t
ORDER BY
t.OrderColumn
; 

这篇关于sql问题相关联合查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！