I have some historical data based on positions and PnL stored in an Oracle XE database. I need a little help with a SQL query.
Positions are captured every 15 minutes along with an associated timestamp (stored as a single number, seconds-since-Epoch). How can I calculate the average position for each day? I know it's a basic question, but I'm not a SQL guy. -Dan ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
