In a Weblogic CMP EJB, how to obtain the maximum value in the specified database column? In WLQL is there something similar to MAX() function in SQL?

oli nilavan

I dont know how to write in WLQL. Another solution is to write the query using SQL inside the weblogic-cmb-rdbms-jar.xml file.


<?xml version="1.0" encoding="UTF-8"?>

< ! [ CDATA[SELECT * FROM Asn_Goal_M WHERE ( orgn_code = #orgnCode and DELETE_FLAG='N') ] ] >