How to add first name and last name in sql

Asked by admin @ 28/10/2021 in Computers and Technology viewed by 282 People

Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Sort the results by employee number. Assume case sensitivity.

Answered by admin @ 28/10/2021

Answer:

The SQL Code to this question can be given as:

Assume that

employee number= EMP_NUMBER //employee number

last name=EMP_L_NAME //employee last name

first name=EMP_F_NAME //employee first name

middle initial=EMP_M_INITIAL //middle initial

employee =EMP //table name

Code:

SELECT EMP_NUMBER ,EMP_L_NAME,EMP_F_NAME,EMP_M_INITIAL

FROM EMP WHERE EMP_L_NAME LIKE '%Smith%'

ORDER BY EMP_NUMBER

Explanation:

In the above SQL(Structure Query Language). It is used to communicate to the database in the form of a query. In the database, there is a table that is an employee(EMP).In this table there are employee number(EMP_NUMBER), last name(EMP_L_NAME) ,first number(EMP_F_NAME) and middle initial(EMP_M_INITIAL) columns. In the above code firstly we use the select command. This command used to return a set of records from the table. This command is part of DML(Data Manipulation Language). In the select command, we select the column that's data we want. then we define the table name where data stored. Then we apply condition by using where clause in that clause we use (%) sign for search data and use the order by clause for show the data into the order of employee number(ascending order).

How to add first name and last name in sql

Similar Questions

What is first name and last name in tamil

What was the name of the first spacecraft in space

How to say what is your last name in spanish

Name the first three planets in our solar system

Name the first 3 planets in our solar system

The first chairman of the atomic energy commission was name

The first part of its name is a body part

Name the scholar who first calculated the value of pi

The first name of the organism's scientific name is the

Last names in spanish speaking countries

The star of which sitcom shares his last name with a common type of wrench?

What is the name of the first manned us spacecraft

Name the first industrial country in the world

Name of first english ship that came to india

The first graphical browser for the www was named

Most viewed questions in Computers And Technology

A customer wants to increase the storage capacity by 25gb

A backup of sewage in the operation's storeroom is considered

Which statement describes a characteristic of gddr synchronous dynamic ram

What is the recommended solution if a computer performs slowly

You can apply several different worksheet themes from which tab

What business computing will look like in the next generation

Which value once represented a very popular modem baud rate that was used with dial-up connections?

Which of the following software programs provides for email communication

Solid yellow line bordering your lane of traffic marks a

Which of the following is not a windows utility program

When is a wrecker considered to be an emergency vehicle

Which operation on a pwc requires more than idle speed

Which of the following statements is true of a database

Which of the following is not true about an entrepreneur

Kitchen gadgets draw a context diagram for the order system