Skip to Content
-1

ORDER BY SQL View

Hi,

I have the following SQL Calculation view that I want ordering by the column "Performance_3W".... this does not happen! Any information will be gratefully received...

BEGIN 

var_out = 
SELECT "d".*
FROM "GDMI_N.0RPO.XSAPPS.CORE_KPI.model/CURRENT_USER" AS "user"
LEFT JOIN (SELECT 
		"W3"."Supervisor_Payroll", 
		"W3"."Supervisor_Name", 
		"W3"."Payroll", 
		"W3"."Engineer", 
		"W3"."Opportunity" AS "Opportunity_3W", 
		ROUND("W3"."Performance",2) AS "Performance_3W",
		"W1"."Opportunity" AS "Opportunity_1W",
		ROUND("W1"."Performance",2) AS "Performance_1W" 
	FROM "GDMI_N.0RPO.XSAPPS.CORE_KPI.model.long_job/Long_Job_Performance_P2P_3W" AS "W3"
	LEFT JOIN "GDMI_N.0RPO.XSAPPS.CORE_KPI.model.long_job/Long_Job_Performance_P2P_1W" AS "W1"
	ON "W3"."Payroll" = "W1"."Payroll"
	ORDER BY ROUND("W3"."Performance",2) ASC) AS "d"
ON "user"."Payroll" = "d"."Supervisor_Payroll"
ORDER BY "d"."Performance_3W" ASC;

END /********* End Procedure Script ************/
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers