database error when using DISTINCT and ORDER BY |
ok i need to repeat my error in details
i want to get only one user_id from my inbox db by using group by or distinct but both not working here is my sql code for group by Code: SELECT message_user_name FROM cms_inbox GROUP BY message_user_id ORDER BY message_time DESC and error i get from it in only latest version on mysql 5.7 is Code: Error Number: 1055 demo on w3schools website HERE it works on that website but dont know why my code is showing error |
Messages In This Thread |
database error when using DISTINCT and ORDER BY - by corey - 05-04-2017, 11:36 PM
RE: database error when using DISTINCT and ORDER BY - by Rufnex - 05-05-2017, 01:42 AM
RE: database error when using DISTINCT and ORDER BY - by corey - 05-05-2017, 03:15 AM
RE: database error when using DISTINCT and ORDER BY - by corey - 05-05-2017, 10:06 PM
RE: database error when using DISTINCT and ORDER BY - by corey - 05-05-2017, 10:20 PM
RE: database error when using DISTINCT and ORDER BY - by Rufnex - 05-07-2017, 12:30 AM
RE: database error when using DISTINCT and ORDER BY - by corey - 05-09-2017, 08:35 PM
RE: database error when using DISTINCT and ORDER BY - by salain - 05-09-2017, 10:44 PM
|