Selecting multiple columns with distinct and without it?

Question

So we learned here to use distinct and list all columns we want to show the distinct values, after that. I want to list a column without the distinct feature in the same statement. Is that possible and how should I do that ?

Answer 1

Please, post an example...

Answer 2

select distinct(fieldname), orherfieldname from table