Question

Write a query to display the company name and last 2 characters of iata and give an alias name as 'iata_number' of all the companies. Display the records sorted in ascending order based on name.

Answer 1

select*from(tablename) where iata_number=(jo aap dalna chaho) %ta;