Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
Problem in Constructor Expressions
Joined: Feb 07, 2005
Oct 30, 2012 01:29:43
select NEW org.UserDto(distinct(orgreg.contactNumber)) from OrganisationRegistration orgreg
The above query throws runtime exception due to
Is there any solution available.
Joined: Oct 01, 2007
Oct 30, 2012 07:41:09
DISTINCT only applies to the entire query (the only exception is its usage with an aggregate function).
Select distinct NEW org.UserDto(orgreg.contactNumber) from OrganisationRegistration orgreg
Blog:Java Persistence Performance
I agree. Here's the link:
subject: Problem in Constructor Expressions
Game on SQL
need 2 rows rather than 5 from this query
Complicated SQL query help
Tell me this Logic
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014