SELECT * FROM TABLE WITH DISTINCT COLUMN
---------------------------------------------------------------
SELECT * FROM [TABLE NAME]
WHERE [ID] IN (
SELECT MIN([ID]) FROM [TABLE NAME] GROUP BY [DISTINCT COLUMN NAME])
Example:
SELECT * FROM [SKILLS] WHERE [ID] IN
(
SELECT MIN([ID]) FROM [SKILLS] GROUP BY [SKILL NAME]
)
---------------------------------------------------------------
SELECT * FROM [TABLE NAME]
WHERE [ID] IN (
SELECT MIN([ID]) FROM [TABLE NAME] GROUP BY [DISTINCT COLUMN NAME])
Example:
SELECT * FROM [SKILLS] WHERE [ID] IN
(
SELECT MIN([ID]) FROM [SKILLS] GROUP BY [SKILL NAME]
)