order by
Good Evening How change case sensitive in insensitive of Order By? I'm no speak english Thank.
↪ replying to formisano
In 9.4 and later which allow sorting by fields not included in select
part of statement:
select
last_name,
irst_name,
middle_initial
from
employee
order by
upper(last_name),
upper(first_name),
upper(middle_initial)
versions before 9.4:
select l
last_name,
first_name,
middle_initial,
upper(last_name),
upper(first_name),
upper(middle_initial)
from
employee
order by
4,5,6