ERROR: syntax error at or near "DISTINCT"

Question

Why do I get this error? I need to select both these as distinct, but Im I coding it wrong here?

ERROR: syntax error at or near "DISTINCT"

SELECT DISTINCT(mfin_score), DISTINCT(empirica_score ) from account_details

Answer 1

You can do:

select distinct mfin_score, empirica_score
  from account_details

Keyword distinct is not a function. It's a keyword to state that you want only distinct tuples on your result set.

Answer 2

DISTINCT is a KEYWORD not a FUNCTION hence it will be better if you try

SELECT DISTINCT mfin_score, empirica_score from account_details