can anyone explain me the output of the 2 below listes Distinct keyword queries! | Sololearn: Learn to code for FREE!
¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita
+ 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;

18th Jun 2017, 5:05 PM
lalit sachdeva
lalit sachdeva - avatar
1 Respuesta
+ 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
18th Jun 2017, 5:20 PM
ChaoticDawg
ChaoticDawg - avatar