+ 1

Selecting multiple columns with distinct and without it?

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 ?

18th Sep 2016, 10:35 AM
David Djordjevic
David Djordjevic - avatar
2 Respostas
+ 2
Please, post an example...
19th Sep 2016, 7:03 AM
Richard Blackburn
Richard Blackburn - avatar
0
select distinct(fieldname), orherfieldname from table
12th Jan 2017, 8:10 PM
Hakkı Karahan
Hakkı Karahan - avatar