查询在sql server中使用table1 coluns值从table2获取计数 [英] query in sql server to get count from table2 using tables1 coluns value as a like in table2

问题描述

我有两个表，即Table1和Table2。 Table1有两列，即Column1和Column2

我需要编写SQL查询来获取Table2.Column1的计数，其中Table2.Column1 = Table1.Column1和Table1.Column2 = 1


你能帮助吗？在此先感谢

I have two tables namely Table1 & Table2. Table1 has two columns namely "Column1" & "Column2"
I need to write SQL Query to get count of Table2.Column1 where Table2.Column1=Table1.Column1 and Table1.Column2=1

Could you please assists? Thanks in advance

推荐答案

这是您的查询

Here is your Query

SELECT COUNT(T1.Column1) FROM @Table1 T1 INNER JOIN @Table2 T2 ON ( (T1.column1=T2.Column1) AND T1.column2=1)

我用以下示例数据对此进行了测试

I have tested this with below sample data

DECLARE @Table1 AS Table(Column1 INT,Column2 INT)
DECLARE @Table2 AS Table(Column1 INT)

INSERT INTO @Table1 
SELECT 1,1
UNION
SELECT 3,1
UNION
SELECT 2,2

INSERT INTO @Table2 
SELECT 1
UNION
SELECT 2

SELECT COUNT(T1.Column1) FROM @Table1 T1 INNER JOIN @Table2 T2 ON ( (T1.column1=T2.Column1) AND T1.column2=1)

根据本例中考虑的样本数据进行此查询的结果

Count = 1



希望这会有所帮助，如果是，则接受并投票给答案

这篇关于查询在sql server中使用table1 coluns值从table2获取计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！