Try this simple query without a sub-query:
SELECT COUNT(DISTINCT component) AS TotalRows
FROM xyz
WHERE labref="NDQA201303001";
Try this simple query without a sub-query:
SELECT COUNT(DISTINCT component) AS TotalRows
FROM xyz
WHERE labref="NDQA201303001";