Eliminate Duplicate

When manipulating data with SQL, you often encounter situations where you want to "eliminate duplicate data." For exampl...