+ 1
can anyone explain me the output of the 2 below listes Distinct keyword queries!
Select Distinc f_name, l_name from customers; And Select Distinc f_name, Distinct l_name from customers;
1 Answer
+ 1
The first will return all f_name and l_name from the customers table where the f_name must be different than the other f_name values returned.
The second will return the same, but both f_name and l_name must be different.
https://www.w3schools.com/sql/sql_distinct.asp