How do I show only unique rows in my datawindow without using SELECT DISTINCT in the SQL?

First sort the data on the column for which you want unique values, then apply the following sort and filter strings to the datawindow.
Sort String: “department_name A”
Filter String: “department_name <> department_name[-1] or GetRow () = 1″