Suppose you ahve a table like the one below and you want to use a select statement to
make another table that includes only
a) the highest prices for each date
b) but if there is only 1 entry for a date and the price is 0, it includes that date too
Is there a way to do this with an SQL statement?
Thanks STEve
______ ____ __
number
of
record date price
______ ____ __
1 1/1 0
2 1/1 7
3 1/3 0
4 1/3 8
5 1/5 0
6 1/8 0
7 1/9 0
8 1/9 8