Group by and select distinct

Hi,

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?

Thanks in advance.

With Regards,

Vijayakrishna.P. Mobile : 9500402305.