I don't think weblogic supports this kind of query. perhaps u should ask this in WL forum.
 
Rupesh
----- Original Message -----
From: Kevin
Sent: Saturday, January 12, 2002 4:34 PM
Subject: WebLogic Query Language

Hi All,
 
Sorry for an off-topic question.
 
I have a container managed persistence entity bean and I want a finder method to return row with largest ID.
 
Normal SQL statement is like this
SELECT      *
FROM         Customer
WHERE      CustomerID =
(   SELECT     MAX(CustomerID)
    FROM        Customer    )
 
The question is how could I translate this SQL statement to WebLogic Query Language
 
Thanks a lot,
Kevin
 

Reply via email to