Can Anyone send the sample Query of weighted sum method?

Question

I am working on some multi objectives optimization problems. i want to make a SQL query which would accomodate this techniques

Mohsin Arif · Answer

Following are the Query which fulfill your requirements just add your factors and run it. select * from ( select Name ,ContactNo,Email, TestMarks, cast ((TestMarks/100) as numeric (18,3)) RatioTestMarks,ExpectedSalary,1- cast ((ExpectedSalary/( select max (ExpectedSalary)+500 from CandidatesData where InitialInterview=1)) as numeric (18,3)) RatioExpectedSalary ,SecondInterview, cast ((SecondInterview/100) as numeric (18,3)) RatioSecondInterview,HRInterview, cast ((HRInterview/100) as numeric (18,3)) RatioHRInterview ,(0.25* cast ((TestMarks/100) as numeric (18,3))) + 0.25*(1- cast ((ExpectedSalary/( select max (ExpectedSalary)+500 from CandidatesData where InitialInterview=1)) as numeric (18,3)))+0.25* cast ((SecondInterview/100) as numeric (18,3))+(0.25* cast ((HRInterview/100) as numeric (18,3))) FinalRatio from CandidatesData where isnull (HRInterview,0)> 0)tbl order by tbl.FinalRatio desc

Kiran Kumari · Answer

Mohsin Arif Thanks

Can Anyone send the sample Query of weighted sum method?

Answers (2)