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.============================================================================================================================

Reply via email to