Distinct with select *

Is it possible to use select * with distinct or write easily something that has the same impact?

I need to select all columns from a table with distinct value, but listing all the columns in select clause wo开发者_开发问答uld be nerve-breaking because the number of columns is over 20!

In Microsoft SQL Server you can write:

select distinct * from MyTable

However, it is considered "best practice" to specify the columns explicitly, partly because it improves the performance of the query, but also to protect yourself from failures that would arise if the database schema were to change in the future

This should work:

SELECT DISTINCT * FROM TABLE_NAME

Use this query:

SELECT DISTINCT Employee, Rank
FROM Employees

Adding the "distinct" keyword right after "select" does the work. For example:

SELECT DISTINCT * FROM TABLE_NAME