[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[eclipselink-users] Help with having clause
|
I'm using EclipseLink 1.1.1 running against Sybase ASE 15. The data I am
working with looks as follows:
ID discriminator SOURCE_RECORD_DATE ADDRESS_1 EXTERNAL_IDENTIFIER
ORGANIZATION
19766 BillTo 2009-08-12 10:34:43.893 4567 Test Dr. 31295-90 AMER
19775 BillTo 2009-08-20 16:18:19.27 4567 Test Dr. 31295-90 AMER
19776 BillTo 2009-08-20 16:55:07.02 4567 Test Dr. 31295-90 AMER
I would like to write a query that would retrieve only the middle row (ID =
19775) but I seem to be having some difficulty trying to locate the correct
SQL/JPAQL. Perhaps its my limited understanding but any assistance would be
greatly appreciated. I know that the HAVING clause should not be used
without a GROUP BY and I guess that is where my difficulty lies.
Thanks in advance.
--
View this message in context: http://www.nabble.com/Help-with-having-clause-tp25138774p25138774.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.