Re: creating a new table from existing one

I have a working solution to the problem in the post above but am wondering if there is a better more efficient way. I was able to get the first quote simply by virtue of the fact that the table is ordered by trade_date, and created a temporary table sorted in descending order by trade_date to g

creating a new table from existing one

I have a database of minute by minute stock prices and I would like to summarize daily information in a 'daily' table, which contains information about the max, min, range of prices, total volume, etc... This works so far: CREATE TABLE daily ( ticker VARCHAR(8) not null, date DAT