tblSensors
ID  CableID SensorName
1   1   Sensor1
2   1   Sensor2
3   1   Sensor3
4   2   Sensor1
5   2   Sensor2
6   2   Sensor3
7   2   Sensor4
8   3   Sensor 5

COUNT query results
Sensor1Count    OtherSenorsCount
3               5

COUNT query
SELECT
    TOP 1 (
        SELECT
            COUNT(cableid)
        FROM
            tblSensors
        WHERE
            CableID = 1
    ) AS Sensor1Count,
    (
        SELECT
            COUNT(cableid)
        FROM
            tblSensors
        WHERE
            CableID = 2
            OR CableID = 3
    ) AS OtherSenorsCount
FROM
    tblSensors

OR IF looking FOR a regular dataset OF records THEN you can USE a UNION query, LIKE:
SELECT
    id,
    SensorName,
    "First Category" AS CatName
FROM
    tblSensors
WHERE
    CableID = 1
UNION
SELECT
    id,
    SensorName,
    "Second Category" AS CatName
FROM
    tblSensors
WHERE
    CableID = 2
    OR CableID = 3

results:
id  SensorName  CatName
1   Sensor1     FIRST Category
2   Sensor2     FIRST Category
3   Sensor3     FIRST Category
4   Sensor1     SECOND Category
5   Sensor2     SECOND Category
6   Sensor3     SECOND Category
7   Sensor4     SECOND Category
8   Sensor 5    SECOND Category