Welcome Guest, Not a member yet? Register   Sign In
database error when using DISTINCT and ORDER BY
#8

Try this:

Code:
SELECT ANY_VALUE(message_user_name) message_user_name, ANY_VALUE(message_user_id) AS message_user_id
FROM cms_inbox GROUP BY message_user_id ORDER BY ANY_VALUE(message_time)
A good decision is based on knowledge and not on numbers. - Plato

Reply


Messages In This Thread
RE: database error when using DISTINCT and ORDER BY - by salain - 05-09-2017, 10:44 PM



Theme © iAndrew 2016 - Forum software by © MyBB