Labels

Android (1) bash (2) boost (2) C (34) C++ (2) cheatsheet (2) CLion (6) css (3) Debian (33) DL (17) Docker (2) Dreamweaver (2) Eclipse (3) fail2ban (4) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (31) javascript (3) Linux (167) Mac (19) Machine Learning (1) mySQL (48) Netbeans (4) Networking (1) Nexus (1) OpenVMS (6) Oracle (1) Pandas (3) php (16) Postgresql (8) Python (9) raid (1) RedHat (14) Samba (2) Slackware (47) SQL (14) svn (1) tar (1) ThinkPad (1) Virtualbox (3) Visual Basic (1) Visual Studio (1) Windows (2)

Monday, 1 May 2023

Selecting distinct columns with MySQL

In the past I was sure it was not possible in MySQL to use DISTINCT on multiple columns, such as below;

SELECT DISTINCT a,b FROM my_table;

and have in the past, instead used something similar to the below as a workaround;

SELECT DISTINCT CONCAT (a,' ', b) FROM my_table;

However, it seems I am remiss and MySQL does indeed support DISTINCT on multiple columns.

 

No comments:

Post a Comment

Note: only a member of this blog may post a comment.