Why is it reasonable to say that no system is 100% efficient?
1 answer:
You might be interested in
Answer:
The table is attached as a picture.
a)
Select VENDOR_CONTACT_LAST_NAME || ', ' || VENDOR_CONTACT_FIRST_NAME "full_name" from VENDORS where VENDOR_CONTACT_LAST_NAME like 'A%' or VENDOR_CONTACT_LAST_NAME like 'E%' order by VENDOR_CONTACT_LAST_NAME,VENDOR_CONTACT_FIRST_NAME;
concatenation operator || is used . Also LIKE is used for pattern matching. full_name is alias for the concatenated column
b) As sample data is not given ,Please test the query for the data given in table
Explanation:
