SQL显示重复条目

Question

I have a SQL code that is pulling information from a database. Here's the code:

$info = "SELECT field_5, record_meta_keywords
FROM cms_custom_database_1
WHERE field_5 > ''
GROUP BY field_5
ORDER BY field_5
DESC LIMIT 10";

The problem is that field_5 has duplicate entries. For example, there are two 868's in that field, but the output is only showing one and not the other. How can I alter this to display all entries and not just one of each number?

Answer 1

You should not use group by without aggregation function

SELECT field_5, record_meta_keywords
FROM cms_custom_database_1
WHERE field_5 > ''
ORDER BY field_5
DESC LIMIT 10

if you want distinct value then use distinct

the use of group by without aggregation function is deprecated in SQL, not allowed (by default) in most recent version of mysql, and produce unpredictable result with other versions (<5.7)

In your case if you want see all the result then just remove order by