I think you can use select distinct * from tablename where col='mycondition' or you may select only required columns, if you get unexpected rows select distinct model,col1,col2,col2 from tablename where col='mycondition'