Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 13
Words: 1209

Apalachia hwy apt phoenix goscreenshot executed code select from employeeresult query

Here is sql code for creating table Employee

/***********Employee table creation sql code ***********************/

[emp_address] [nvarchar](250) NULL,

[emp_city] [nvarchar](50) NULL,

[emp_gender] [nvarchar](10) NULL,

[dob] [date] NULL,

[emp_salary] [nvarchar](50)NULL,

[job_id] [nvarchar](50) NOT NULL,

) ON [PRIMARY]

GO

/***********inserting 1 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

/***********inserting 2 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

/***********inserting 3 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

/***********inserting 4 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

/***********inserting 5 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

/***********inserting 6 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

/***********inserting 6 row data***************/

USE [OGIEDATABASE]

,[emp_fname]

,[emp_address]

,[emp_phn]

,[emp_gender]

,[emp_marriagestatus]

,[emp_salary]

Screenshot of executed code

  • Write a query, that shows the employee's name in one column, entitled "Full Name" in the following format - Bob Smith. 

Answer: select emp_fname + ' '+ emp_lname As Full_Name from employees

Twila Thompson

Sara Sanderson

Select * from Job_title

Result:

J5 SENIOR Manager Hr manager job open

Screenshot

Result:

  • Join two tables in the example database and use LIKE to restrict the records based on Telephone Area Codes. Take a screenshot of the executed code and the results.

Answer:

select * from employees where emp_fname like ('_a%' ) or emp_fname like ('_e%' )or emp_fname like ('_o%' )or emp_fname like ('_u%' )

Result:

Copyright © 2009-2023 UrgentHomework.com, All right reserved.