YOUR AD GOES HERE

Incorrect result when select count distinct with order by and math function in MySQL 5.7.17

Published 22, Feb 2026

The Debug Zone

0 73 Download

Description:
Today's Topic: Incorrect result when select count distinct with order by and math function in MySQL 5.7.17

Thanks for taking the time to learn more. In this video I'll go through your question, provide various answers & hopefully this will lead to your solution! Remember to always stay just a little bit crazy like me, and get through to the end resolution.

Don't forget at any stage just hit pause on the video if the question & answers are going too fast.

Content (except music & images) licensed under CC BY-SA meta.stackexchange.com/help/licensing

Just wanted to thank those users featured in this video:
guaizitang (https://stackoverflow.com/users/8511019/guaizitang
davejal (https://stackoverflow.com/users/3664960/davejal)

Trademarks are property of their respective owners.
Disclaimer: All information is provided "AS IS" without warranty of any kind. You are responsible for your own actions.

Please contact me if anything is amiss. I hope you have a wonderful day.

Related to: mysql, group-by, distinct

Releted More Videos

You May Also Like

YOUR AD GOES HERE

Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 02:18
Dba: INFORMATION_SCHEMA.COLUMNS - how to distinguish between table columns and view columns
Sophia Wagner
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 01:14
SQL : Select top ranked overlapping segment SQL
Hey Delphi
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 24:56
Navigating Enterprise ELT towards Data Democracy and Cost Efficiency by Stellantis - dltHub Paris
dltHub
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script
This Excel Shortcut Selects an Entire Row INSTANTLY
Row To Result (R2R)
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 25:50
10th Maths 1 All Imp Activity Based Questions 2026 | 10th Algebra Board Exam 2026 | JR Tutorials |
JR Tutorials
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 08:49
Aadhaar Card Me Father Name / Husband Name Kaise Change Kare 2026 | S/O D/O W/O Correction Online
Raj Technical
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 48:46
Let’s Talk About Ellii!
MN Adult Education Professional Development
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 11:03
DDL Commands in SQL | Oracle Database
Learn Coding
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 01:20
SQL : SQL Select list of last records with condition
Hey Delphi
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 21:41
Rig Veda : Hymnes 10.160 et 161.
Rig Veda: Une vieille civilisation pour le futur
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script
???? Learn Numbers 1 to 20 by Singing! ????✨
Smile and Learn - English
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 10:18
Adding Random Variables
Iain Explains Signals, Systems, and Digital Comms
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 00:00
2 SQL SELECT 1 TABLE
Mark Hay
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script
How To Become A Python Programmer in 2024 ????‍???????? | Intellipaat #Technology #Programming #Career
Intellipaat
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 14:37
How to do an SQL SELECT in Delphi
Mr Long Education - IT & CAT
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 05:09:45
Python Full Course in Hindi | Beginner to Advanced | Amit Thinks | Class 11th 12th
Amit Thinks
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 15:29
Python Tutorial for Beginners 1: Install and Setup for Mac and Windows
Corey Schafer
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 01:55
21-Wordpress: Duplicating MySql Database
Samy Ramzi (Geek)
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 11:48
SSC GD Slot Booking 2026 Kaise Kare | How to Select Date, City & Shift
CHIRAG CLASSES
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 03:44
SELECT, FROM & WHERE: Your First Real SQL Query
Unrote
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 01:15
SQL : select rows with longest substring of the string
Hey Delphi
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script
Correction Pen Vs Correction Tape #shorts #SYShorts 87
Student Yard
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 03:20
QTableView Selecion Change (2 Solutions!!)
Roel Van de Paar
Incorrect Result When Select Count Distinct With Order By And Math Function In MySQL 5717 - YouTube Auto PHP Script 02:23
TDDD55 Lesson II Execise I-A, String Concatination
John Tinnerholm
Share Modal

Share this link via

Or copy link

YOUR AD GOES HERE