Closed

Fix a single MySQL query

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.

Skills: MySQL

See more: mysql repair crashed table, mysql workbench repair table, repair mysql database phpmyadmin, mysql repair table innodb, the storage engine for the table doesn't support repair, mysql repair table command line, mysql repair command, repair table mysql query, fix mysql query, fix mysql query error, php mysql query format table, mysql query php table css, optimize mysql query software, fix broken mysql database, write mysql query

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #15220463

43 freelancers are bidding on average £19 for this job

rinsadsl

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

£22 GBP in 1 day
(436 Reviews)
7.9
avinashjain09

Hello, I have expertise in database, I can solve this very quickly. Please provide the sql database, so I can create the query. Can we have more discussion. Relevant Skills and Experience mysql Proposed Milestones £1 More

£18 GBP in 0 days
(86 Reviews)
6.2
£23 GBP in 1 day
(124 Reviews)
6.0
mahmoudgamal008

I have more than 5 years of professional and practical experience in SQL and MySQL. Relevant Skills and Experience I can solve this query for you in less than 5 minutes. I have more than 1800 answers in Stackoverflow( More

£20 GBP in 0 days
(29 Reviews)
5.2
vinaysinghh

A proposal has not yet been provided

£13 GBP in 1 day
(32 Reviews)
4.9
£23 GBP in 0 days
(18 Reviews)
4.9
zyeloncomputech

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can fix your MySQL query issue according to your exact requirements. Relevant Skills and Experience Please Before More

£88 GBP in 1 day
(17 Reviews)
4.7
phiona06

select [url removed, login to view], bidTime from table t1 join (SELECT thesamefield,max(bidTime) as maxtime from table GROUP BY thesamefield) t2 on maxtime=bidtime and t1.thesamefield= [url removed, login to view] Соответствующие More

£13 GBP in 0 days
(18 Reviews)
4.4
micbassa75

I'm a sql developer. I can do it quickly Competenze ed esperienze rilevanti sql Pietre Miliari proposte £13 GBP - sql developer

£13 GBP in 1 day
(35 Reviews)
4.3
polarjin2017

Hi Relevant Skills and Experience I am good in sql query Proposed Milestones £18 GBP - 2

£18 GBP in 1 day
(4 Reviews)
4.0
imagicaworld

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

£50 GBP in 1 day
(8 Reviews)
4.1
PiasKumarDas

........ Relevant Skills and Experience ... Proposed Milestones £18 GBP - milestone ...

£18 GBP in 1 day
(5 Reviews)
3.3
azmatakhtar

Can you send me table script and a query .i will maake sure its donee now

£18 GBP in 1 day
(12 Reviews)
3.3
bhupen2606

Hi, i have extensive experience in SQL and MySQL. Let me know the details of your query and i should be able to provide a quick solution. Relevant Skills and Experience SQL, MySQL Proposed Milestones £10 GBP - SQL qu More

£10 GBP in 1 day
(3 Reviews)
2.2
frankoke16

I can help you with this project. I am a full time programmer. Relevant Skills and Experience I use .Net framework integrated with SQL, SSRS, MySql, Access, Oracle, Crystal Report, Oracle E-Business Suite 12, Oracle 1 More

£20 GBP in 1 day
(3 Reviews)
2.0
£18 GBP in 1 day
(1 Review)
1.5
bdmindra

Hi Greetings!!!!! After a careful attention to your job post I understand you are seeking for "Fixing a single MySQL query" Relevant Skills and Experience We are an established Web Design and Development company with More

£20 GBP in 1 day
(1 Review)
0.6
jspetrak

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.

£10 GBP in 1 day
(0 Reviews)
0.0
andreasstavrou

Hello i am experienced with databases and i can do that for you. please contact me Relevant Skills and Experience sql Proposed Milestones £18 GBP - database query

£18 GBP in 1 day
(0 Reviews)
0.0
nidhi1509

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.

£13 GBP in 1 day
(0 Reviews)
0.0