Hello, I am trying to get the phone number from which the oldest call was made. Is there a more efficient query for this?
Loading
Hello, I am trying to get the phone number from which the oldest call was made. Is there a more efficient query for this?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Jul 21, 2022, 12:56 PM
Try,
SELECT PhoneNumber FROM mobile JOIN calls USING(MobileID) ORDER BY CallDate LIMIT 1;