troubleshooting Question

What would the alternative be to this subquery?

Avatar of Bruce Gust
Bruce GustFlag for United States of America asked on
MySQL Server
2 Comments1 Solution10 ViewsLast Modified:
I have this as a subquery in my SELECT:

 LEFT JOIN requirements r ON t.ID = (SELECT r.INTID_ FROM requirements r WHERE r.INTID_=t.ID ORDER BY r.ID DESC LIMIT 1)

One of my team members suggested that I use a different approach by using "MAX."

You have a one to many relationship and the, "r.INTID_" that I want to connect with is the most recent row, hence my sorting by ID.

How would I incorporate the MAX() function in this scenario so I'm accomplishing the same thing, but in a way that is, perhaps, a little more efficient?

Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros