MySQL Database Questions Which command is used to join the P DESCRIPT and P_PRIC

Question

MySQL Database Questions

Which command is used to join the P DESCRIPT and P_PRICE fields from the PRODUCT table and the V NAME, V_AREACODE, V PHONE, and V CONTACT fields from the VENDOR table where the values of V CODE match and the output is ordered by P_PRICE? A. The_clause is especially useful when the listing sequence is important. a. ORDER BY b. SELECT c. GROUP BY d. HAVING SELECT PDESCRIPT, P_PRICE, VNAME, V CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE>VENDORV CODE; ORDER BY P PRICE; The aggregate functions, such as COUNT, MIN, MAX, AVG, and SUM. clause is valid only when used in conjunction with one of the SQL b. a. HAVING b. SELECT c. WHERE d. GROUP BY SELECT PDESCRIPT, P_PRICE, VNAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE VENDOR.V CODE; ORDER BY P PRICE C. Which of the following commands is used to join the P_DESCRIPT and P PRICE fields from the PRODUCT table and the V NAME, V AREACODE, V PHONE and V CONTACT fields from the VENDOR table where the values of V CODE match? SELECT P DESCRIPT, P_PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE VENDOR.V CODE; ORDER BY P_PRICE; a. d. SELECT P DESCRIPT, P PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE SELECT P DESCRIPT, P PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V-CODE => VENDOR.V-CODE; ORDER BY P PRICE; PRODUCT.V CODEVENDOR.V CODE; SELECT PDESCRIPT, P_PRICE, V_NAME, V CONTACT, V AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT·V-CODE VENDOR CODE; d. SELECT PDESCRIPT, P_PRICE, V NAME, V_CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE VENDOR.V CODE;

Explanation / Answer

//Note:- if you have any query then comment below.please upvote.

Answer:-

A)   a) ORDER BY

B) d) GROUP BY

C) d)  

D) c)  

Explanation:-

The ORDER BY keyword is used to sort the result-set in ascending or descending order.

The SQL GROUP BY clause is used to group the result set based on common value present in the result set.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.