select distinct

I have a table with the following columns

customerno        name
1234              John
1234              Bill
1235              Jan
1236              Mark


What I want for a result set is:
1234              John
1235              Jan
1236              Mark

If I use "select distinct customerno,name from table" I still get all of the rows.

"select distinct customerno from table" gets the unique customer numbers, but not the names.

I have to believe there is a sql statement that will accomplish this... Can anyone help? Received on Fri Aug 27 1999 - 19:53:01 CDT