My database is set to be case insensitive.
Is there a way to case sensitive DISTINCT query?
My table Employees has columns Name and Email
George 10 AM
Tom 10 AM
Tom 11 AM
Tom 12 PM
TOM 10 AM
TOM 11 AM
When i query select distinct name from Employess, the result set is
George, Tom as expected.
How can I query so that result set is George, Tom, TOM?