About DISTINCT

1-10 of 67Refresh
JPA Doc
105

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
105

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
105

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
44

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
Manual
40

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
Issue
29

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
27

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
Forum
26

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
25

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
24

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