Display the empno, ename and salary if salary is incremented by 10% of all employees

Question

1.00/5 (2 votes)

See more:

I am not able to understand the below question:

Display the empno, ename and salary if salary is incremented by 10% of all employees.

What I have tried:

SQL

select empno, ename, salary from emp _
wher salary = (select * from emp wher salary = salary + 0.1 * salary)

I have no idea if it is 100 % correct or not.

Posted 26-Sep-23 0:48am

Harshita1803

Updated 2-Oct-23 3:50am

Deeksha Shenoy

v2

Add a Solution

Comments

Richard Deeming 26-Sep-23 6:55am

... where salary = salary + 0.1 * salary

Even ignoring the typo, the only way that could possibly match a record would be if the salary was zero.

... where salary = (select * from ...

That's never going to work. The sub-query would select multiple columns from multiple rows; the DBMS would have no idea which value you wanted to match.

If you don't understand the question, go back and ask your teacher for clarification.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-09-26T01:08:00

We can't see the actual question your teacher has set you, and the version you show here is lacking in any significant detail, rendering it pretty much unanswerable.

And as Richard has said, your SQL is never going to work.

So start with the question: go back and read it carefully - it almost certainly contains details as to what you need to do and in what order. Then re-read your notes on the last lecture as this is normally relevant to the homework that is set.

If you are still having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]