UNION and ORDER BY clause
From: <shaikh74_at_my-deja.com>
Date: Wed, 08 Nov 2000 21:03:53 GMT
Message-ID: <8ucf3i$9gk$1_at_nnrp1.deja.com>
Date: Wed, 08 Nov 2000 21:03:53 GMT
Message-ID: <8ucf3i$9gk$1_at_nnrp1.deja.com>
[Quoted] Dear Oracle gurus:
[Quoted] 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 - 22:03:53 CET