How about
SELECT date,MAX(price) as Price FROM mytable GROUP BY date INTO CURSOR myCursor
>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