you can do something like: select phone_number, count(1) from your_table_name_here group by phone_number
> -----Original Message----- > From: Jan Blomqvist [mailto:[EMAIL PROTECTED] > Sent: Monday, March 15, 2004 8:27 AM > To: [EMAIL PROTECTED] > Subject: any select statement like uniq in unix > > > Hi! Is there a select statement , wich works like the command > uniq in unix, > if I shall list a table with a column wich for example is > telephonenumber > and the same number occurs like 1000 times, and I wan,t i > present just once > and also the count how many times it occurs in the table. > > > /Jan Blomqvist > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
