Using a value from one query in second query sql

Question

SELECT AS, COUNT(*)
FROM Table1
HAVING COUNT(AS)>1
group BY AS;

This produces the result

AS      COUNT
5       2

I then want to use the AS value in another query and only output the end result. Is this possible.i was thinking something like.

SELECT * 
FROM 
TABLE 2 
Where AS =(
           SELECT AS, COUNT(*)
           FROM Table1
           HAVING COUNT(AS)>1
           group BY AS;
);

Gordon Linoff · Accepted Answer · 2015-01-07 21:59:55Z

1

This is called a subquery. To be safe, you would use in instead of = (and as is a bad name for a column, because it is a SQL key word):

SELECT * 
FROM TABLE2 
WHERE col IN (SELECT col
              FROM Table1
              GROUP BY col
              HAVING COUNT(col) > 1
             );

Your first query is also incorrect, because the having clause goes after the group by.

answered Jan 7, 2015 at 21:59

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mureinik · Accepted Answer · 2015-01-07 22:00:19Z

0

You could use a subquery with the in operator:

SELECT *
FROM   table2
WHERE  AS IN (SELECT   AS
              FROM     table1
              GROUP BY AS
              HAVING   COUNT(*) > 1)

answered Jan 7, 2015 at 22:00

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Collectives™ on Stack Overflow

Using a value from one query in second query sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related