Geek asks and answers

SQL query to find a value that appears more than once

I have a small racing project that uses a MySQL database. I am trying to find a good query to capture the details of all the drivers that are placed in the top 3 positions in more than two races. Here is a small breakdown of the table:

Drivers table:
driver_id, driver_name, driver_age, etc misc details

Entry table:
entry_id, driver_id, placed

So, usually this will not be a big problem, as I could just do JOIN on driver_idand then use a column WHERE on my 'placed'to reduce the results; however, the client absolutely must have guys who were placed in the top 3 more than once. I will just take care of this on the side of the script, but the application they use to output the data is very strange.

Thank!

+3
source share
1 answer
select *
from `Entry table`
where placed <= 3
group by driver_id 
having count(*) > 1

- ... , having count

+3

More articles:


All Articles