147 | Problem with distinct select, order by and equivalent alias/attribute path distinct s_location " + "from Street s " + "left join s.location as s_location ... (); q1 = "select distinct s.location " + "from Street s ... , Location.class).getResultList(); String q2 = "select distinct s.location |
145 | Multi selection and distinct in a criteria queryhi, How can I realize multi selection with the criteria api concerning distinct? I.e. doing something like SELECT DISTINCT $1, $2 wouldn't work because I do only have something like criteria.multiselect(...) and nothing like builder.distinct(selection) so that I could do something like criteria |
140 | Distinct ErrorHi, I'm getting a NullPointerException thrown on using DISTINCT. The query works fine if I don't have distinct. However thats NOT a solution as the code generating the query is used for other queries, and some of them do need the distinct. Its only a simple query: QUERY: SELECT DISTINCT $1 FROM |
136 | ObjectDB internal error on 2.6.4.b10 for query with DISTINCTI observed that on new ObjectDb v.2.6.4.b10 query below causes internal exception SELECT DISTINCT $1 FROM Pa3DictionaryItem $2 JOIN $2.values $1 WHERE ($2.namespace == 'com.anritsu.pa3.ttcn3' AND $2 ... Could you comment this? Raised issue: Issue #1176 - DISTINCT key causing internal exception on 2.6.4.b10 |
115 | distinct(distinct)Method javax.persistence.criteria.Subquery Subquery<T> distinct( boolean distinct ) Specify ... . A false value will cause duplicates to be retained. If distinct has not been specified, duplicate ... method. Parameters: distinct - boolean value specifying whether duplicate results must be eliminated |
115 | distinct(distinct)Method javax.persistence.criteria.AbstractQuery AbstractQuery<T> distinct( boolean distinct ... to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate |
115 | distinct(distinct)Method javax.persistence.criteria.CriteriaQuery CriteriaQuery<T> distinct( boolean distinct ... to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified ... AbstractQuery method. Parameters: distinct - boolean value specifying whether duplicate results |
73 | SELECT clause (JPQL / Criteria API) and they consume less memory. SELECT DISTINCT Queries that use projection may return duplicate results ... can be eliminated easily in JPQL by using the DISTINCT keyword: SELECT DISTINCT c.currency FROM Country AS c WHERE c.name LIKE 'I%' The only difference between SELECT and SELECT DISTINCT |
70 | GROUP BY and HAVING clauses to grouping by the GROUP BY clauses before arriving at the SELECT clause. GROUP BY as DISTINCT ... calculations - the GROUP BY functions merely as a DISTINCT operator. For example, the above query (which does not use aggregates) is equivalent to the following query: SELECT DISTINCT SUBSTRING(c |
31 | Issue with DISTINCT SelectIt is getting more and more frustrating :( We've introduced distinct select instead of regular ... expression '$3' for distinct results at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.QNF.l ... distinct select so I doubt its an issue in our query. Here it goes: SELECT DISTINCT $1 FROM com.quasado |
