是否有其他写作范围的方式(is there other way of writing range)
嗨,例如我必须在我的公式中写这个
Sheet1!A1:HM232
有没有其他方式写这个(例如只使用数字,没有任何字母)
Sheet1!Cells[1,1]:Cells[232,221]
提前致谢!
hi for example i have to write this in my formula
Sheet1!A1:HM232
is there any other way of writing this (for example using only numbers, without any letters)
Sheet1!Cells[1,1]:Cells[232,221]
thanks in advance!
原文:https://stackoverflow.com/questions/1008838
更新时间:2022-01-07 18:01
最满意答案
尝试:
SELECT Service, COUNT(qno) AS [qno_served] FROM Visit WHERE NOT EXISTS ( SELECT * FROM Matter WHERE Matter.TrackNo = Visit.TrackNo AND Matter.code = 'a') GROUP BY Service
Try:
SELECT Service, COUNT(qno) AS [qno_served] FROM Visit WHERE NOT EXISTS ( SELECT * FROM Matter WHERE Matter.TrackNo = Visit.TrackNo AND Matter.code = 'a') GROUP BY Service
相关问答
更多-
UPDATE tbl1 t1 SET status = 2 WHERE status = 1 AND NOT EXISTS ( SELECT NULL FROM tbl2 t2 WHERE t2.key = t1.key AND t2.status <= 1 ) UPDATE tbl1 t1 SET status = 2 WHE ...
-
看起来我的问题在我的另一个问题中间接解决了。 谢谢,贝丝。 UPDATE tbl1 INNER JOIN tbl1 ON Tbl1.ID = Tbl2.ID SET Tbl2.[thing1] = [Tbl1].[thing1], Tbl2.[ thing2] = [Tbl1].[thing2], Tbl2.[thing3] = [Tbl1].[thing3], Tbl2.[thing4] = [Tbl1].[ thing4], Tbl2.[ thing5] = [Tbl1].[thing5]; I ...
-
case1:s_id存在然后忽略子(f_id)和子(d_id)行 使用CTE ,解决方案可能如下所示: WITH x AS ( SELECT d_id, f_id FROM tbl2 t2 JOIN tbl1 t1 ON t1.assetid = t2.s_id ) SELECT t.* FROM tbl1 t LEFT JOIN d ON d.d_id = t.assetid LEFT JOIN f ON f.f_id = t.assetid WHERE d. ...
-
SQL:从多行填充单行(tbl 1)(tbl 2);(SQL: Populate single row(tbl 1) from multiple rows(tbl 2); cross DB)[2022-06-25]
聚合忽略空值,所以.... SELECT PersonID, Min(CASE WHEN ApplicationID = 1 THEN PersonApplicationID END) AS 'DRIMaster', Min(CASE WHEN ApplicationID = 6 THEN PersonApplicationID ... -
如何在sql中主表是tbl1时忽略来自tbl2的行?(How to ignore lines from tbl2 while main table is tbl1 in sql?)[2022-02-23]
尝试: SELECT Service, COUNT(qno) AS [qno_served] FROM Visit WHERE NOT EXISTS ( SELECT * FROM Matter WHERE Matter.TrackNo = Visit.TrackNo AND Matter.code = 'a') GROUP BY Service Try: SELECT Service, COUNT(qno) AS [qno_served] FROM Visit WHERE NOT ... -
创建两个表如下: 然后使用此查询 select t1.ID, t1.Name, t1.Sex, t2.OrderDate, t2.OrderCode from Table1 t1 inner join Table2 t2 on t1.ID = t2.ID; Create two tables as following: and then use this query select t1.ID, t1.Name, t1.Sex, t2.OrderDate, t2.OrderCode from Table ...
-
使用in语句似乎总体上看起来很慢,如果可能的话我会使用exists语句,但我不确定它是否在SQL Server 2008上受支持。其他选项是左连接也很慢。 一个存在或(不存在)语句就像这样工作 select * from #tbl1 t1 where not exists (select displayid from #tbl2 where displayid = t1.displayid) 注意使用别名t1,你不必在子选择中选择一列,你可以使用通配符*。 我发现这种类型的查询效率更高,因为它直接在2个 ...
-
首先创建表 CREATE TABLE TBL2 ( IDTest INT NOT NULL PRIMARY KEY ,Nome Varchar(100) ) GO 填充数据 INSERT INTO TBL2 (IDTest, Nome) SELECT IDTest, Nome FROM TBL1 WHERE HasValue = 1 Create the table first CREATE T ...
-
我想你想要结合union all : select num, 1 as id from tbl2 where abc <> 0 union all select num, 2 as id from tbl2 where abd <> 0 union all select num, 3 as id from tbl2 where dft <> 0; 如果你想从第一个表中获取id: select t2.num, t1.id from tbl2 cross join (select id from t ...
-
mysql插入或选择 - 将列从tbl1复制到tbl2(mysql insert into or select into - copy column from tbl1 into tbl2)[2022-04-24]
首先,您需要将新列添加到tbl2 ALTER TABLE tbl2 ADD domain char(100) //or whatever the type is 然后你需要像这样填充它: UPDATE tbl2 JOIN tbl1 ON tbl1.url = tbl2.url AND tbl1.urlkey = tbl2.urlkey SET tbl2.DOMAIN = tbl1.DOMAIN First you need to add the new column to tbl2 ALTER TABL ...