Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can set the value of the previous query

Tags:

t-sql

how to SET return value to new query ?

query like :

DECLARE @count;   

SELECT COUNT(*) FROM a WHERE x = 1;

SET @count = //result_last_query

SELECT * FROM b WHERE z = @count;
like image 741
Aris bagus Avatar asked Nov 28 '25 21:11

Aris bagus


2 Answers

As simple as :

 SELECT *  FROM b
     where z=(select count(*) FROM a FROM a WHERE x = 1;)}

You dont even require any variable declaration

like image 157
Ranjana Ghimire Avatar answered Dec 01 '25 03:12

Ranjana Ghimire


thanks good solution

I modified the code of answers

SELECT  *
FROM    B
WHERE   id IN (
                SELECT COUNT(*) AS count
                FROM A
                WHERE x = 1
              )
like image 43
Aris bagus Avatar answered Dec 01 '25 03:12

Aris bagus



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!