DB2 - SELECT - INTO Statement

[James Allen]

Hello Members

I need correct syntax for writing SELECT - INTO statement with ORDER BY clause. Can anyone of you please help me. Does DB2 support such SELECT Statement.

Awaiting your early response.

Regards
Allen

[sanereddy]

Hello,

DB2 Support select into.... here is an example...

INSERT INTO table1
SELECT field1, field2 FROM table2
WHERE field3='test';


Hope this helps...

Thanks,

[James Allen]

Hello Senereddy

Thanks for your quick response,
I would like to confirm again the SELECT Statement with an Order By Clause.
After you send me the syntax, I will try to test it on my system.
I am asking very simple syntax, Hope you wont mind.

Thanks again.
Cheers
Allen