Note that you could always do something like:
WITH original_query AS (
SELECT DISTINCT ...
)
SELECT *
FROM original_query
ORDER BY lastname, firstname;
OR
SELECT * FROM (
SELECT DISTINCT
) sub_query
ORDER BY lastname, firstname
I am thinking you cannot alter the existing ORDER BY other
Change the order by to order by lastname, firstname, refid, appldate
From: [email protected] [mailto:[email protected]]
On Behalf Of Nathan Mailg
Sent: Saturday, September 14, 2013 10:36 PM
To: [email protected]
Subject: [SQL] removing duplicates and using sort
