MySQL Database Questions A. What is the command used to list the P CODE, P DESCR
ID: 3732386 • Letter: M
Question
MySQL Database Questions
A. What is the command used to list the P CODE, P DESCRIPT, P INDATE, and P PRICE fields from the PRODUCT table in ascending order by P PRICE? C. What command is used to produce a list of only those unique values, for the column Vendor Code (V_CODE), those are different from one another? a. P CODE, P DESCRIPT, P INDATE, P PRICE SELECT FROM PRODUCT SEQUENCE BY ONLY V CODE SELECT FROM PRODUCT P PRICE; SCRIPT, P INDATE, P_PRICE SELECT P CODE, P DE FROM PRODUCT SELECT DIFFERENT V CODE FROM PRODUCT; ORDER BY PPRICE; C. DISTINCT V CODE SELECT FROM PRODUCT P CODE, P DESCRIPT, P INDATE, P PRICE SELECT FROM PRODUCT ASCENDING BY P PRICE; d. UNIQUE V CODE SELECT FROM PRODUCT: P CODE, P DESCRIPT, P_INDATE, P_PRICE SELECT FROM PRODUCT LIST BY P PRICE; D. clause is applied to the output of a GROUP BY operation. a. WHERE GROUP b. LIKE c. DISTINCT d. HAVING The B. What is the SQL command that lists the contents of the EMPLOYEE table sorted by last name, first name, and initial? a. SELECT EMP LNAME, EMP FNAME, EMP_INITIAL, EMP AREACODE, EMP PHONE FROM EMPLOYEE LIST BY EMP LNAME, EMP FNAME, EMP INITIAL; b. SELECT EMP PHONE FROM EMPLOYEE DISPLAY BY EMP LNAME, EMP FNAME, EMP_INITIAL; EMP LNAME, EMP FNAME, EMP INITIAL, EMP AREACODE, EMP LNAME, EMP FNAME, EMP INITIAL, EMP AREACODE, SELECT EMP PHONE FROM EMPLOYEE SEQUENCE BY EMP LNAME, EMP FNAME, EMP INITIAL; d. EMP LNAME, EMP FNAME, EMP INITIAL, EMP AREACODE, SELECT EMP PHONE FROM EMPLOYEE ORDER BY EMP LNAME, EMP FNAME, EMP INITIAL;Explanation / Answer
Questino 1:
Answer: B
Syntax:
select *
from table_name
order by column_name;
Questino 2:
Answer: D
Syntax:
select *
from table_name
order by column_name1,column_name2,column_name3...;
Questino 3:
Answer: C
Syntax:
select distinct column_name
from table_name
Questino 4:
Answer: D
Syntax:
select *
from talbe_name
group by column_name
having codition;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.