Re: Out of memory using order by on 19 records!

[Thimble Smith]

On Tue, May 18, 1999 at 02:26:45PM -0700, Shafir wrote:
> I read somewhere that this might be possible by selecting into another 
> (temporary) table and then running the select on that table.
> 
> Can anyone help me on how to write the sql commands for that?

You need to first create a temporary table with all of the columns
that you want to select.

Then do:

INSERT INTO temporary_table (columnA, columnB, columnC)
SELECT columnA, columnB, columnC FROM the_table WHERE some_conditions

Then do:

SELECT columnA, columnB, columnC FROM temporary_table ORDER BY columnC

Tim