Question
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Database Processing Fundamentals, Design, and Implementation
Authors: David M. Kroenke, David J. Auer
14th edition
133876705, 9781292107639, 1292107634, 978-0133876703
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App