You have the following table: CONSULTANT (CON#, Cname, Expertise, DNUMBER) c1 Jo

Question

You have the following table:

CONSULTANT (CON#,        Cname,            Expertise,        DNUMBER)

                                                c1                    Joy                  C/S                  1

                                                c2                    Bob                 OOSA             1

                                                c3                    Jack                 C++                 5

                                                c4                    Cindy              Oracle              NULL

Write SQL statement that prints CON#, Cname, and Expertise. Display Expertises by converting from C++ to Java and from OOSA to UML. Others remain the same.

(Can I display 'Java' instead of 'C++' without updating the table?

Explanation / Answer

SELECT CON#,Cname,Expertise, CASE WHEN Expertise = 'C++' THEN 'Java' WHEN Expertise = 'OOSA' THEN 'UML' END FROM CONSULTANT;

Case statement in sql is used to display the customized values of attribute if the condition is true. Thus when Expertise value in a row is C++ , it will display Java and when Exoertise value is OOSA , it will display UML as Expertise. The Case will not change the actual values in the table.

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

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