Hi, I have a table T_QC_EXTRACT with many columns, few of them are STORY_ID, EXECUTION_STATUS. I want to fetch the distinct STORY_ID based on EXECUTION_STATUS IN ('PASSED','BLOCKED');
SELECT DISTINCT STORY_ID FROM T_QC_EXTRACT WHERE EXECUTION_STATUS IN ('PASSED','BLOCKED'); Please suggest a way to achieve this using Cayenne. Thanks, Sampath Uppula ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/tim/disclaimer.html">http://tim.techmahindra.com/tim/disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================