Duplicate data

Navigation
2

I have a table where the clients create the budget and each product inserted a registration is made to separate, but I want to make a query by the name of the client that the system does not take more than one, but one. thanks in advance

    
asked by anonymous 04.03.2015 / 20:10

1 answer

2

Use distinct . If you better specify your conditions and the bank used would be easier, but it would look something like this: 

SELECT DISTINCT(cliente) FROM orcamento
    
04.03.2015 / 20:18
Query to return only the highest values Detecting colors or geometric shapes of an image