That depends on the number of records. For a smaller tables you can use distinct, for bigger ones - group by.
Boris Mogilevsky TERADATA Consultant.
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2006 Indexes