SQL : Why does "SELECT DISTINCT a, b FROM..." return fewer records than "SELECT DISTINCT A + '|' + B

Channel:
India Hey Delphi
Subscribers:
76,600
Published on ● Video Link: https://www.youtube.com/watch?v=06gSvm6Idew


Duration: 1:20
0 views
0

SQL : Why does "SELECT DISTINCT a, b FROM..." return fewer records than "SELECT DISTINCT A + '|' + B FROM..."?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

So here is a secret hidden feature I promissed to tell you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
After that, type the word 'awesome' on your keyboard.
The progress bar on YouTube will be altered to a flashing rainbow.

Here's a short introduction about myself,
Welcome, I'm Delphi.
I can provide you with assistance to help you answer your questions.
SQL : Why does "SELECT DISTINCT a, b FROM..." return fewer records than "SELECT DISTINCT A + '|' + B FROM..."?
If you need more specific answers, please reach out to me through comments or chat.
Please feel free to share your answer or insights on the answer by leaving a comment below.
Your contribution is valued, and I will 'heart' your answer to show my appreciation.
DISTINCT B + a, does return A FROM..." + than : SQL "SELECT "SELECT Why b records '|' DISTINCT fewer FROM..."?



Other Videos By Hey Delphi


2023-04-16HTML : why is span element not working with this piece of code
2023-04-16C++ : What Are Some Quirks/Surprises with Using .mm Files in Objective-C?
2023-04-16NodeJS : How to cache node_modules on Docker build?
2023-04-16jQuery : How to animate translate properties with Velocity.js?
2023-04-16PYTHON : How do I enumerate() over a list of tuples in Python?
2023-04-16jQuery : How do I get jQuery's Uploadify plugin to work with ASP.NET MVC?
2023-04-16PYTHON : How to fix AttributeError: partially initialized module?
2023-04-16C++ : When open an image using imread with no second argument, what is the color mode? BGR or RGB?
2023-04-16C++ : How to properly chain boost::mpl::inherit_linearly and boost::mpl::inherit so placeholders can
2023-04-16Android : How do you annotate Pair parameter in Kotlin?
2023-04-16SQL : Why does "SELECT DISTINCT a, b FROM..." return fewer records than "SELECT DISTINCT A + '|' + B
2023-04-16MySQL : How do I get the IDENTITY / AUTONUMBER value for the row I inserted in pymysql
2023-04-16SQL : What is the difference between Postgres DISTINCT vs DISTINCT ON?
2023-04-16C++ : Documentation of "invalid pointer value" conversion in C++ implementations
2023-04-16C# : How to sort enum using a custom order attribute?
2023-04-16PYTHON : How to draw polygons with Python?
2023-04-16Windows : can I change 'turn off the display' time in a bat file?
2023-04-16SQL : How to show all privileges from a user in oracle?
2023-04-16PYTHON : Why and how are Python functions hashable?
2023-04-16Android : how to get Theme attributes values
2023-04-16SQL : How to get all children of a node in tree structure ? SQL query?