如何用sql语句查询表中某列不重复的所有项

Answer 1

　　SELECT *
　　FROM tablea
　　WHERE (number NOT IN
　　(SELECT ta.number
　　FROM tablea AS ta INNER JOIN
　　 tablea AS tb ON ta.number = tb.number AND ta.id tb.id))