Answer the question
In order to leave comments, you need to log in
How to set comparison query as a percentage?
Tell me how to correctly compare SickLeaveHours > 20% VacationHours ,
SELECT LoginID
FROM HumanResources.Employee where (SickLeaveHours > 20*VacationHours) but it gives only 3 values out of 1000, correct where the error is.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question