如何将1个SQL列中的输出更改为每行中相同的结果

Question

下面是我的SQL语句：

Select glm_prft_ctr as STORE, glm_account as ACCOUNT, glm_group AS CLASS,
glm_description as DESCRIPTION, 
glm_amt_period0 + glm_amt_period1 + glm_amt_period2 + glm_amt_period3 +
glm_amt_period4 as BALANCE
From gl_master_in
Where glm_prft_ctr = 410
Or glm_prft_ctr = 14101
AND glm_series = 'FY12'
Group by glm_account, glm_description, glm_prft_ctr, glm_group,
glm_amt_period0, glm_amt_period1, glm_amt_period2, glm_amt_period3, glm_amt_period4

以下是结果和提示问题的原因：

STORE   ACCOUNT CLASS   DESCRIPTION         BALANCE
410     36000   RE      RETAINED EARNINGS   396367.61
14101   36000   RE      RETAINED EARNINGS   -20505.93

我需要让STORE的结果是7410是返回的所有行。

Answer 1

Select 7410 as STORE, 
       glm_account as ACCOUNT, 
       glm_group AS CLASS,
       glm_description as DESCRIPTION, 
       glm_amt_period0 + glm_amt_period1 + glm_amt_period2 + glm_amt_period3 + glm_amt_period4 as BALANCE
From gl_master_in
Where glm_prft_ctr = 410 Or glm_prft_ctr = 14101
AND glm_series = 'FY12'
Group by glm_account, glm_description, glm_prft_ctr, glm_group, glm_amt_period0, glm_amt_period1, glm_amt_period2, glm_amt_period3, glm_amt_period4

Answer 2

如果我没理解错的话，就像这样：

Select '7410' as STORE, glm_account as ACCOUNT, glm_group AS CLASS,
glm_description as DESCRIPTION, 
glm_amt_period0 + glm_amt_period1 + glm_amt_period2 + glm_amt_period3 +
glm_amt_period4 as BALANCE
From gl_master_in
Where glm_prft_ctr = 410
Or glm_prft_ctr = 14101
AND glm_series = 'FY12'
Group by glm_account, glm_description, glm_prft_ctr, glm_group,
glm_amt_period0, glm_amt_period1, glm_amt_period2, glm_amt_period3, glm_amt_period4

Answer 3

在查询中，您有

Where glm_prft_ctr = 410 
Or glm_prft_ctr = 14101 

这使得STORE = 410或14101。你想..。

Where glm_prft_ctr = 410 
Or glm_prft_ctr = 14101 
Or glm_prft_ctr = 7410

或

Where glm_prft_ctr = 7410

或者从410/14101获取商店信息并将其命名为7410的其他提供的答案之一。