Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1.Write the SQL statement to display employee names, designation and cities of those employees whose designation starts with M and ends with R and whose

Q1.Write the SQL statement to display employee names, designation and cities of those employees whose designation starts with “M” and ends with “R” and whose salary is greater than 2500.

Q2.Display the following results: 

  • Write the SQL statement to display the hire days of all employees (All days must come in one column). 
  • Write the SQL statement to ROUND OFF all the salaries up to 2 decimal places.

Step by Step Solution

3.41 Rating (164 Votes )

There are 3 Steps involved in it

Step: 1

SELECT name designation city F... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals, Design, and Implementation

Authors: David M. Kroenke, David J. Auer

14th edition

133876705, 9781292107639, 1292107634, 978-0133876703

More Books

Students also viewed these Databases questions

Question

Write an SQL statement to display WarehouseID.

Answered: 1 week ago

Question

What are some common forms of product differentiation?

Answered: 1 week ago

Question

What are the attributes of a technical decision?

Answered: 1 week ago

Question

Why is a database considered to be self-describing?

Answered: 1 week ago

Question

Name three vendors of DBMS products.

Answered: 1 week ago

Question

Explain how the PL/SQL statement FOR variable IN cursorname works.

Answered: 1 week ago