Question

How can we get all the unique rows in MySQL result set?

Answer 1

MySQL DISTINCT with LIMIT clause. In case you use the DISTINCT clause with the LIMIT clause, MySQL stops searching immediately when it finds the number of unique rows specified in the LIMIT clause. The following query selects the first 5 non-null unique states in the customers table.