This will show approvementStatusId = 7. Problem is next one query, I want all result ID that show up, all the duplex removes include the ID that got duplex it self for exemple: ID: 5000, with ApprovementStatusid = 7 shows up, and ID 5000 got also ApprovementStatusID = 4, if it detect this, it will remove ID 5000 completely from the result. Is this possible to do?
SELECT ID FROM [system_Prod].[System].[Approvement] where ApprovementStatusId = 7
Do more with