when we use distinct keyword will it be applicable to only the preceding column or will it be applicable to all columns listed in select query? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

when we use distinct keyword will it be applicable to only the preceding column or will it be applicable to all columns listed in select query?

22nd Jan 2017, 7:10 PM
samhitha
3 Answers
+ 3
applicable only for the preceding coloum
22nd Jan 2017, 10:40 PM
mahendra mahajan
mahendra mahajan - avatar
+ 2
Only the first column that follows Distinct
26th Jan 2017, 12:33 AM
Srinivasa Rao
Srinivasa Rao - avatar
+ 1
applicable to the first column after distinct
26th Jan 2017, 11:56 AM
Aditya Agarwal
Aditya Agarwal - avatar