我想在一个查询中获得2个单独的表的2行的总和。我试过这个:
SELECT SUM(Items.Price) AS [Total Items], SUM(Stores.Cash) AS [Total Cash]
FROM Items, Stores
但是,查询返回的是Price *门店数量和门店现金总额*商品数量之和。哪里出了问题?
我在故事板中创建了简单的应用程序(只有一个控制器),我把scrollview和里面的scrollview对UITextFileds。在控制器内部,我添加了如下功能
- (void)touchesBegan:(NSSet *)touches withEvent:(UIEvent *)event {
[self.name resignFirstResponder];
[self.number resignFirstResponder];
// I have tried with and without this line but doesn't work
我有下面的查询,它返回门店编号及其所在地区,以及2016年门店销售额的总和。
SELECT
EU.[STORE NO]
,EU.REGION
,SUM(SA.SALESEXVAT) AS 'STORE SALES'
FROM
[BHXSQL2014-DEV].BManalytics.dbo.EUactivestores EU
INNER JOIN
EUUKSQL01.dashboard.dbo.stocksalesaggregateweek sa
ON eu.[Store No] = sa.[br