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

You are viewing 1/3rd of the document.
Purchase the document to get full access instantly.

Immediately available after payment
Both online and downloadable
No strings attached

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.