Justin
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.