如何包含此SQL子查询的绝对数值? [英] How to include this SQL subquery for absolute number's value?

问题描述

我为Access DB编写了此查询.

I have this query written for Access DB.

queryText = "SELECT Technicians.ID, firstName, lastName, Technicians.[Zone],
COUNT(technicianAssignedId) AS JobsDone, 
MAX(Faults.timeCompleted) AS LastJobTime,
MIN(Technicians.[Zone] - & faultZone &) AS Distance ' MIN has no use
FROM Technicians LEFT OUTER JOIN Faults ON
Technicians.ID = Faults.technicianAssignedID 
WHERE Specialization = '" & specialization & "'
`AND Availability = 'available' 
GROUP BY Technicians.ID, firstName, lastName, Availability,` Technicians.[Zone], Specialization 
ORDER BY 7 DESC"

我有这个目的以获得绝对价值

I have this to get absolute value

SELECT CASE
WHEN value < 0 THEN value * -1
ELSE number *1 END
AS VALUE
FROM DB;

现在，具有Distance别名的列最终可能会变成负数，而我需要使用(* -1)作为正数，但是我不知道如何将它们放在一起.

Now the column with Distance alias may end up as negative number which I need as positive by using (* -1), but I can't figure out how to put this together.

感谢您的帮助

推荐答案

尝试

ABS(Technicians.[Zone] - & faultZone &) AS Distance 

请参见 ABS文档

这篇关于如何包含此SQL子查询的绝对数值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！