DB query - total number of BPT components used in each test case


Slect ts_name, count(*)

from (
SELECT
B.TS_TEST_ID,
A.BC_BPT_ID,
C.CO_ID,
A.BC_CO_ID,
B.TS_NAME,
C.CO_NAME
FROM
Table1 A
INNER JOIN
Table2 B
ON A.BC_BPT_ID = B.TS_TEST_ID
INNER JOIN
Table C
ON A.BC_co_ID = C.CO_ID ) BPT
group by ts_name

Happy Testing!

Comments

Popular posts from this blog

Software Testing @ Microsoft

Trim / Remove spaces in Xpath?