Keith,

Trying to work through your suggestions:
I'm getting "Misuse of aggregate max()"


>CREATE VIEW TICKMAX
>AS
> SELECT ASK, BID, TRADEPRICE, TIMESTAMP, SYMBOL
>    FROM TICKDATA
>   WHERE TIMESTAMP = MAX(TIMESTAMP)
>GROUP BY SYMBOL;
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to