4Find the names of all the vendors and the vendor contact fi

4.Find the names of all the vendors and the vendor contact first name, whose contact first name starts with an A, in ascending alphabetical order of contact last name.

oracle sql query.

Solution

You have not posted all details of Schema.
But based on your question i have prepared a quey(idea).
You have to use correct table name and columns name.

You have to use LIKE and ORDER BY clause in this query
select vendors, first_name
from vendors_table
where first_name LIKE \'A%\'
order by last_name