pmsguy
asked on
SQL Distinct on multiple columns
I want to get the distinct set of rows based on the uniqueness of multiple columns
ex: I have a table last,first whose data is:
smith, john
smith, john
smith, fred
i want to run SQ - something similar to:
select distinct last,first from table;
should return:
smith,john
smith,fred
ex: I have a table last,first whose data is:
smith, john
smith, john
smith, fred
i want to run SQ - something similar to:
select distinct last,first from table;
should return:
smith,john
smith,fred
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Could you explain more
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.