Link to home
Start Free TrialLog in
Avatar of Justin
JustinFlag for United States of America

asked on

SQL to find all rows with the highest number value

Hello, I am having some trouble coming up with a SQL statement that will give me the results that I need and was hoping yall could help


given a table like:

ID  Day/Time                instance
1   Monday 10:00       1
2   Tuesday 10:00       1
3   Tuesday  12:00      2
4   Tuesday  18:00      3
5   Wednesday 9:00   1          


How can I query all values on the same day with only the highest instance number? so that i return something like:


ID  Day/Time                instance
1   Monday 10:00       1
4   Tuesday  18:00      3
5   Wednesday 9:00   1    


Thank you very much for taking a look and any help you can provide.
ASKER CERTIFIED SOLUTION
Avatar of Justin
Justin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial