UNION and ORDER BY

From: <shaikh74_at_my-deja.com>
Date: Wed, 08 Nov 2000 20:25:22 GMT
Message-ID: <8uccr6$7c7$1@nnrp1.deja.com>

Dear Oracle gurus:

I have two SQL statements which are run through UNION and UNION ALL, and the results are exact same. They contain duplicate rows (rows which are in common within two SQLs). I would like to get distinct rows in the final result set. Also, in the final set I would them to run through ORDER BY clause. Your assistance values a million. Thanks a bunch. Please reply to shaikh74_at_visto.com Asad

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 08 2000 - 14:25:22 CST