Getting more salary in lakhs then his expireance.

Question

Table having employee joining data and monthly salary. G et the employee list who is getting more salary in lakhs then his expireance.

SWAROOP P · Answer

Just compare his joining date with present date like getDate().

Abhay Shanker · Answer

ok but we need a constraint for compare.Means by which basis you will compare the employee getting sakary more than his experience. Any where you need to maintain the Experience salary relationship. then only you can compare and get result

SWAROOP P · Answer

Actually this one of interview question. please assume for employee table having empNameEmpSalJoinDate.

Abhay Shanker · Answer

Please clarify your requirement in details.If possible shared with us your sql Table Structure