Question
Write a SQL statement using employees table to display the first name column, the index value if letter n is contained/found in first name, the
Write a SQL statement using employees table to display the first name column, the index value if letter n is contained/found in first name, the first name after replacing n with *, and the first name after deleting n in its beginning or ending.
=========================
Write a SQL statement using employees table to display the 3rd of a salary, the 3rd of a salary rounded with no decimal part, and the 3rd of a salary truncated with no decimal part.
==============================
Considering that all employees are still working in the company, write a SQL statement using employees table to display the first name, date hired, the number of days he/she is employed, and the number of years he/she is employed.
=============================
database(oracle)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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 Started