Query returned values in SQL

Question

I would like to write an SQL query which uses results from previous one.

For example - I have a table Orders with fields: order_id, date and value. I need to get all dates from column date where value is larger than 5:

SELECT date 
FROM Orders 
WHERE value > 5;

Then I need to return all values for dates, which are +2 days from the returned ones. Is it possible to write short query without using LOOP statement?

Here is an example table:

I am expecting to get the result:

Please provide sample data and expected results.

GMB
– GMB

2020-02-07 00:14:11 +00:00
Commented Feb 7, 2020 at 0:14 — GMB
– GMB, Commented Feb 7, 2020 at 0:14
Also, which version of MySQL are you running?

GMB
– GMB

2020-02-07 00:14:32 +00:00
Commented Feb 7, 2020 at 0:14 — GMB
– GMB, Commented Feb 7, 2020 at 0:14
dev.mysql.com/doc/refman/8.0/en/…

PM 77-1
– PM 77-1

2020-02-07 00:17:01 +00:00
Commented Feb 7, 2020 at 0:17 — PM 77-1
– PM 77-1, Commented Feb 7, 2020 at 0:17

zip · Accepted Answer · 2020-02-07 00:21:21Z

1

his will give you what you need.

select date, value  
from Orders where date in
(
  SELECT date + INTERVAL 5 DAY as date
  FROM Orders 
  WHERE value > 100;
)

answered Feb 7, 2020 at 0:21

zip

4,0612 gold badges13 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Query returned values in SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related