About DISTINCT

1-10 of 69Refresh
JPA Doc
158

distinct(distinct)

Method javax.persistence.criteria.AbstractQuery AbstractQuery 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
JPA Doc
158

distinct(distinct)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery 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
JPA Doc
158

distinct(distinct)

Method javax.persistence.criteria.Subquery Subquery distinct(   boolean distinct ) Specify ... . A false value will cause duplicates to be retained. If distinct has not been specified, duplicate ... AbstractQuery method. Parameters: distinct - boolean value specifying whether duplicate results
Manual
42

SELECT clause (JPQL / Criteria API)

less memory. SELECT DISTINCT Queries that use projection may return duplicate results. For example ... 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 is that the later
Issue
41

Issue with DISTINCT Select

It 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 ... more meaningful. hi, Well, the query works perfect without using distinct select so I doubt its an issue in
Forum
39

Problem with distinct select, order by and equivalent alias/attribute path

distinct s_location "             + "from Street s "             + "left join s.location as s ... ();                 q1 = "select distinct s.location "             + "from Street s ... , Location.class).getResultList();                 String q2 = "select distinct s.location
Manual
39

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.name, 1
Forum
39

Multi selection and distinct in a criteria query

hi, 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
Forum
38

Distinct Error

Hi, 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
Issue
37

DISTINCT key causing internal exception on 2.6.4.b10

I 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 ... not in '', just remove DISTINCT and you will see no problems with this query Second, I have attached