Operation Details |
Description: | Returns the maximum percentage for the specified status, type and user name. |
Sterotype: | ns |
SQL |
SELECT DISTINCT (percentage) FROM EvidenceApprovalCheck WHERE typeCode = :typeCode AND userName = :userName AND recordStatus = :recordStatus AND percentage = ( SELECT MAX(percentage) INTO :percentage FROM EvidenceApprovalCheck WHERE typeCode = :typeCode AND userName = :userName AND recordStatus = :recordStatus ) |