i think a simple test with an EXISTS and correlated subquery will get you want you want:

With YOURTABLE (TICKET,STATUS)

AS

(

SELECT 9543,1 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9544,1 UNION ALL

SELECT 9546,1 UNION ALL

SELECT 9547,1 UNION ALL

SELECT 9547,5

)

--the above is just setup data to represent your data , wherever it is.

--data like that makes it easy for anyone to offer helpful posts.

--proposed example is just what is below.

SELECT

*

FROM YOURTABLE OPENTIX

WHERE NOT EXISTS(SELECT

1

FROM YOURTABLE CLOSEDTIX

WHERE CLOSEDTIX.TICKET = OPENTIX.TICKET

AND CLOSEDTIX.STATUS = 5)

AND OPENTIX.STATUS = 1