I am currently selecting a number of rows, joining another table but can have duplicate entries. I want to remove the duplicates (which I have done), but I want to keep the one with the latest time (bidTime) and using MAX(bidTime) doesn't work. Using ORDER BY doesn't work because it needs to order by from the JOIN table. Maybe I need a subquery, but I'm not familiar with those.
It's a 2 minute job for people with someone with adequate MySQL skills.
42 freelancers are bidding on average £19 for this job
I have lot of experience in mysql query, hope i can do it, thanks Relevant Skills and Experience mysql, join query, max, orderby Proposed Milestones £22 GBP - Milestone
Hi Relevant Skills and Experience I read your description and i can do this job.i have a lot of experience in this field and i can do.I waited your positive response. Thanks Proposed Milestones £50 GBP - D
I have 5 years of experience as Database Developer using MySql and Oracle and have written these kind of queries before also. I am sure on providing you with the desired result in minimal time.
I have worked on SQL reports for two years. I might already know what is wrong with your current query to database. Stay tuned, I'm still working on this proposal.