Answer the question
In order to leave comments, you need to log in
Another problem with the subquery. What to do with aggregate functions?
Colleagues, tell me, is it possible to use aggregate functions in an attachment?
Query doesn't work(
Expected result: output order with earliest start time
select order_id from t2
where t2.START_TIME=(
select min(t2.start_time)
from t2)
Answer the question
In order to leave comments, you need to log in
Try this:
select order_gid from t2
where t2.START_TIME=(
select min(t3.start_time)
from t2 t3)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question