4- write a query that displays the employee’s last namewith the first latter cap

Question

4- write a query that displays the employee’s last namewith the first latter capitalized and all other letters lowercase,and the length of the names, for all employees whose name startswith J,A,orM Give each column an appropriate label.

Sort the results by the employees last names..

                             Name

                       length

Abel

                                                                  4

Matos

5

Mourgos

7

                             Name

                       length

Abel

                                                                  4

Matos

5

Mourgos

7

Explanation / Answer

Dear.., selct ename, LENGTH(ename) from employee WHEREINITCAP(ename)='j','A','M'; LENGTH(ename) shows the length of a string as anumeric value. INITCAP(ename) first letter be captilized. You have any doubts cramster is there for you. You have any doubts cramster is there for you.

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---