General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only