what is the sql query for this

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

SQL

table Employee
EmpId
Name
MonthlySalary
DateofJoining

Suggest  a sql server query to find out the employee details whose having salary greater than their yers of experiance

Posted 13-Jun-14 4:12am

Telstra

Updated 13-Jun-14 4:26am

v2

Add a Solution

Comments

DamithSL 13-Jun-14 10:18am

What!
is there any employee who get less than 100 salary in your company?

Telstra 13-Jun-14 10:22am

LOL!
do you have idea how to find this answer. It is asked to me today in interview.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jun-14 10:26am

Wrong. :)

goathik 13-Jun-14 10:30am

are you trying to troll us with that troll they did to you on that interview, mister? ;)

goathik 13-Jun-14 10:34am

suppose i have 3 years of experience, the select must return me, only if i earn 3+ dollars? It really makes no sense... or perhaps... you wanted to ask for the employee that earns the better salary, even tho he worked there for less time? suppose Victor works there for 3 years and he already gets $5000, although Alex still gets $2000, even he is there for 10 years. So that select should show Victor first, then Alex?

Telstra 13-Jun-14 10:35am

help me to find the annswer`

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jun-14 10:52am

See my answer. :)

phil.o 13-Jun-14 11:50am

This makes no sense at all.
'having a salary greater than their years of experience': if any employee does not fall into this category, then for sure he is mispaid, by far.
My answer would be: the selection criteria is not well chosen, and I would also explain why. That would show to your interviewer that you can have a critic analyze of the work that is assigned to you.

goathik 13-Jun-14 12:32pm

Thumbs up for that answer! I would do the same. If my boss still insists he is right, then he could try making a further explanation or just ask someone else to do the job, but at least you won't be blamed if anything runs into total chaos

phil.o 13-Jun-14 12:37pm

There is the ultimate method: proof with a pen and a piece of paper :)
You write down each employee, along with its experience and salary, and proove that, whatever the experience, the salary will always be greater.
Or you can write down the domains: eg Experience [0..40] (40 years should cover most cases ^^), monthly salaries [100..7500] (well, that depends on the currency, of course).

4 solutions

Solution 6

Instead OF DATEDIFF We Can Use Now Directly YEAR And MONTH function Available..
..
Thanks

Posted 9-Sep-14 19:01pm

Yash Raichura

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 · Accepted Answer · 2014-06-13T04:34:00

Solution 1

Try something along the lines of

SQL

SELECT * FROM Employee WHERE MonthlySalary > DATEDIFF(yy, DateofJoining, GETDATE())

But to be honest, if you can't work that out for yourself, you are applying for the wrong jobs...

Posted 13-Jun-14 4:34am

OriginalGriff

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-06-13T04:51:00

Quote:
do you have idea how to find this answer. It is asked to me today in interview.

If you think practically, it is a wrong question.

But logically, it is asked to make you write the query which would check the Salary by comparing the Year difference between the DateofJoining and Current Date.

Demo - [Demo] Find Employees having Salary more than their Experience[^]

DamithSL · Accepted Answer · 2014-06-13T04:42:00

Solution 2

Check SQL Server DATEDIFF() Function[^]
Demo[^]

Posted 13-Jun-14 4:42am

DamithSL