The output of "select * from table group by col1" and "select distinct(col1) from table" appear to be same. 

But in SQL, group by returns all columns and distinct retrieves only that column values over which the function is ran. 

Is there any way to retrieve non duplicate rows based on a single column (similar to group by in SQL) in MonetDB?