SQL Display the employee names in this format: Lastname(in upper case)<comma>First_name(in initcaps) from employees using...

Question

Question

SQL Display the employee names in this format: Lastname(in upper case)<comma>First_name(in initcaps) from employees using...

 SQL

Display the employee names in this format: Lastname(in upper case)<comma>First_name(in initcaps) from employees using NESTED FUNCTIONSName the column as ‘Formatted Name’

Eg: STEVEN,Fox

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

SELECT CONCAT(UPPER(LastName), ",", FirstName) AS 'Formatted Name'
FROM Employees;

Thanks and regards
if you like the answer please give a thumbs up
if you have a problem, feel free to comment.

UPDATE:

SELECT CONCAT(UPPER(Lastname), ",", First_name) AS 'Formatted Name'
FROM employees;

i have updated the answer's casing according to your question, see if this works.

Add a comment

Answer 2

Similar Homework Help Questions

SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. ...

SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type should be "USA Phone Number" (Length=12) or "International Phone Number" (Length=18) or "Unknown" based on the length of the phone number. Sort the display in desc order of phone number type Use Either CASE or DECODE. Output Column Heading: First Name, Last Name, Phone Number, Phone Number Type
SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type...

SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type should be "USA Phone Number" (Length=12) or "International Phone Number" (Length=18) or "Unknown" based on the length of the phone number. Sort the display in desc order of phone number type Use Either CASE or DECODE. Output Column Heading: First Name, Last Name, Phone Number, Phone Number Type
SQL query: Write a SQL statement using the employees table and retrieve employees whose monthly salary...

SQL query: Write a SQL statement using the employees table and retrieve employees whose monthly salary (including their commission) is greater or equal to 5,000 but less than or equal to 17,000 (we are assuming the salary on the table is monthly). In other words, if their monthly salary was 1000 and their commission was .2, their total monthly salary would be 1200 and given the criteria above this instance would not be selected. Please display the full name of...

Produce the query. Provide SQL to produce a list of employee names, along with hire_date and...

Produce the query. Provide SQL to produce a list of employee names, along with hire_date and email, and in order with the most recent hire last. Display of hire should be formatted like May, 2, 1998. provide meaninful column names for the expressions in the ouput. (Hr.employees) table
Answer the following question in SQL: 6. Display employees’ LastName, FirstName and only the year value...

Answer the following question in SQL: 6. Display employees’ LastName, FirstName and only the year value from each employee’s hire date SQL File: https://pastebin.com/tR98LUb3 Expert Answer
WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...

WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns. -- Format this column with the last name, a comma, a space, and the first name like this: -- Doe, John -- Sort the result set by last name in ascending sequence. -- Return only the contacts whose last name begins with a letter from M to Z. -- ...

Use the HR database for all the questions in this lab. For each item in this lab, paste the SQL y...

Use the HR database for all the questions in this lab. For each item in this lab, paste the SQL you used to complete the task and the number of rows retrieved. Ensure you follow the coding standards listed in the ETSU SQL standards guide found on D2L. Save this document as a PDF and name it your_name_lab7.pdf Display the employees’ first name, last name and phone number of employees with salaries greater than 10,000 dollars. SELECT first_name, last_name, phone_number,...
Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee...

Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee id, first name, last name, job title and email of all employees working in Asia (i.e. all countries coming from the region ‘Asia’). This query must be implemented as a nested query! (ii) Using SELECT statements of SQL, find the employee id, first name, last name, job title and supervisor id of employees who had worked for more than 3 years and completed...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...

Do these codes look right for the following 5 statements. This is using Oracle SQL: Write...

Do these codes look right for the following 5 statements. This is using Oracle SQL: Write a query that displays the title, ISBN, and wholesale cost of books whose wholesale cost is more than the average of all books. Format the retail price with dollars and cents. Write a query that displays the title and publication date of the oldest book in the BOOKS table. Format the date with the complete name of the month and a comma after the...

SQL Display the employee names in this format: Lastname(in upper case)<comma>First_name(in initcaps) from employees using...

Homework Answers

Add Answer to:
SQL Display the employee names in this format: Lastname(in upper case)<comma>First_name(in initcaps) from employees using...

Post as a guest

Earn Coins

SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. ...

SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type...

SQL query: Write a SQL statement using the employees table and retrieve employees whose monthly salary...

Produce the query. Provide SQL to produce a list of employee names, along with hire_date and...

Answer the following question in SQL: 6. Display employees’ LastName, FirstName and only the year value...

WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...

Use the HR database for all the questions in this lab. For each item in this lab, paste the SQL y...

Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

Do these codes look right for the following 5 statements. This is using Oracle SQL: Write...

​​​​​​​ SQL Display the employee names in this format: Lastname(in upper case)<comma>First_name(in initcaps) from employees using...

Homework Answers