how can we use distinct statement in sql with where statement?

suppose i have a table that has 4, 5 columns. i want to show distinct values from 1 column and rest of the columns' values corresponding to that in the table. what would be the general code for that irrespective of the database. i want the distinct supplierid and the rest of the rows associated with it. im trying this but it doesn't work:SELECT * FROM Products WHERE supplierid distinct; i want to display all records from the table where the supplier id is distinct