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;
As simple as :
SELECT * FROM b
where z=(select count(*) FROM a FROM a WHERE x = 1;)}
You dont even require any variable declaration
thanks good solution
I modified the code of answers
SELECT *
FROM B
WHERE id IN (
SELECT COUNT(*) AS count
FROM A
WHERE x = 1
)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With