I have results of a column where the cities and states appear such as: Los Angeles, CA.
How can I retrieve only the state's abbreviation?
I installed Oracle 10g and use SQL Plus for the queries.
Thanks for the input, everyone!
I have the following code:
select pil_pilotname, pil_flight_pay
from pilots group by pil_pilotname, pil_flight_pay
having pil_flight_pay > 2586.67...
Separate names with a comma.