Subqueries (Hibernate JavaDocs)

java.lang.Object
- org.hibernate.criterion.Subqueries

```
public class Subqueries
extends Object
```
Factory class for criterion instances that represent expressions involving subqueries.

See Also:
Restrictions, Projection, Criteria

Method Summary

Methods
Modifier and Type	Method and Description
`static Criterion`	`eq(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a given literal as being equal to the value in the subquery result.
`static Criterion`	`eqAll(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.
`static Criterion`	`exists(DetachedCriteria dc)` Creates a criterion which checks for the existence of rows in the subquery result
`static Criterion`	`ge(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the value in the subquery result.
`static Criterion`	`geAll(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the subquery result.
`static Criterion`	`geSome(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values in the subquery result.
`static Criterion`	`gt(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a given literal as being greater-than the value in the subquery result.
`static Criterion`	`gtAll(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is greater-than ALL the values in the subquery result.
`static Criterion`	`gtSome(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the subquery result.
`static Criterion`	`in(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is IN the values in the subquery result.
`static Criterion`	`le(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the value in the subquery result.
`static Criterion`	`leAll(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the subquery result.
`static Criterion`	`leSome(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values in the subquery result.
`static Criterion`	`lt(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a given literal as being less-than the value in the subquery result.
`static Criterion`	`ltAll(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is less-than ALL the values in the subquery result.
`static Criterion`	`ltSome(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is less-than SOME of the values in the subquery result.
`static Criterion`	`ne(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a given literal as being not-equal to the value in the subquery result.
`static Criterion`	`notExists(DetachedCriteria dc)` Creates a criterion which checks for the non-existence of rows in the subquery result
`static Criterion`	`notIn(Object value, DetachedCriteria dc)` Creates a criterion which checks that the value of a literal is NOT IN the values in the subquery result.
`static Criterion`	`propertiesEq(String[] propertyNames, DetachedCriteria dc)` Creates a criterion which checks that the value of multiple given properties as being equal to the set of values in the subquery result.
`static Criterion`	`propertiesIn(String[] propertyNames, DetachedCriteria dc)` Creates a criterion which checks that the value of multiple given properties as being in to the set of values in the subquery result.
`static Criterion`	`propertiesNotEq(String[] propertyNames, DetachedCriteria dc)` Creates a criterion which checks that the value of multiple given properties as being not-equal to the set of values in the subquery result.
`static Criterion`	`propertiesNotIn(String[] propertyNames, DetachedCriteria dc)` Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result.
`static Criterion`	`propertyEq(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property as being equal to the set of values in the subquery result.
`static Criterion`	`propertyEqAll(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property equals ALL the values in the subquery result.
`static Criterion`	`propertyGe(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is greater-than-or-equal-to the value in the subquery result.
`static Criterion`	`propertyGeAll(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is greater-than-or-equal-to ALL the values in the subquery result.
`static Criterion`	`propertyGeSome(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is greater-than-or-equal-to SOME of the values in the subquery result.
`static Criterion`	`propertyGt(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is greater-than the value in the subquery result.
`static Criterion`	`propertyGtAll(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is greater-than ALL the values in the subquery result.
`static Criterion`	`propertyGtSome(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is greater-than SOME of the values in the subquery result.
`static Criterion`	`propertyIn(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is in the set of values in the subquery result.
`static Criterion`	`propertyLe(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is less-than-or-equal-to the value in the subquery result.
`static Criterion`	`propertyLeAll(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is less-than-or-equal-to ALL the values in the subquery result.
`static Criterion`	`propertyLeSome(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is less-than-or-equal-to SOME of the values in the subquery result.
`static Criterion`	`propertyLt(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is less-than the value in the subquery result.
`static Criterion`	`propertyLtAll(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is less-than ALL the values in the subquery result.
`static Criterion`	`propertyLtSome(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is less-than SOME of the values in the subquery result.
`static Criterion`	`propertyNe(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is not equal to the value in the subquery result.
`static Criterion`	`propertyNotIn(String propertyName, DetachedCriteria dc)` Creates a criterion which checks that the value of a given property is not-in the set of values in the subquery result.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Method Detail
  - exists
```
public static Criterion exists(DetachedCriteria dc)
```
    Creates a criterion which checks for the existence of rows in the subquery result
    
    Parameters:
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    ExistsSubqueryExpression
  - notExists
```
public static Criterion notExists(DetachedCriteria dc)
```
    Creates a criterion which checks for the non-existence of rows in the subquery result
    
    Parameters:
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    ExistsSubqueryExpression
  - propertyEqAll
```
public static Criterion propertyEqAll(String propertyName,
                      DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property equals ALL the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyGtAll
```
public static Criterion propertyGtAll(String propertyName,
                      DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is greater-than ALL the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyLtAll
```
public static Criterion propertyLtAll(String propertyName,
                      DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is less-than ALL the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyGeAll
```
public static Criterion propertyGeAll(String propertyName,
                      DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is greater-than-or-equal-to ALL the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyLeAll
```
public static Criterion propertyLeAll(String propertyName,
                      DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is less-than-or-equal-to ALL the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyGtSome
```
public static Criterion propertyGtSome(String propertyName,
                       DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is greater-than SOME of the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyLtSome
```
public static Criterion propertyLtSome(String propertyName,
                       DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is less-than SOME of the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyGeSome
```
public static Criterion propertyGeSome(String propertyName,
                       DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is greater-than-or-equal-to SOME of the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyLeSome
```
public static Criterion propertyLeSome(String propertyName,
                       DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is less-than-or-equal-to SOME of the values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyIn
```
public static Criterion propertyIn(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is in the set of values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyNotIn
```
public static Criterion propertyNotIn(String propertyName,
                      DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is not-in the set of values in the subquery result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyEq
```
public static Criterion propertyEq(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property as being equal to the set of values in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyNe
```
public static Criterion propertyNe(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is not equal to the value in the subquery result. The assumption is that the subquery returns a single result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression
  - propertyGt
```
public static Criterion propertyGt(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is greater-than the value in the subquery result. The assumption is that the subquery returns a single result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression, propertyGtAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyGtSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
  - propertyLt
```
public static Criterion propertyLt(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is less-than the value in the subquery result. The assumption is that the subquery returns a single result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression, propertyLtAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyLtSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
  - propertyGe
```
public static Criterion propertyGe(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is greater-than-or-equal-to the value in the subquery result. The assumption is that the subquery returns a single result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression, propertyGeAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyGeSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
  - propertyLe
```
public static Criterion propertyLe(String propertyName,
                   DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given property is less-than-or-equal-to the value in the subquery result. The assumption is that the subquery returns a single result.
    
    Parameters:
    propertyName - The name of the property to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertySubqueryExpression, propertyLeAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyLeSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
  - propertiesEq
```
public static Criterion propertiesEq(String[] propertyNames,
                     DetachedCriteria dc)
```
    Creates a criterion which checks that the value of multiple given properties as being equal to the set of values in the subquery result. The implication is that the subquery returns a single result. This form is however implicitly using tuple comparisons
    
    Parameters:
    propertyNames - The names of the properties to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertiesSubqueryExpression
  - propertiesNotEq
```
public static Criterion propertiesNotEq(String[] propertyNames,
                        DetachedCriteria dc)
```
    Creates a criterion which checks that the value of multiple given properties as being not-equal to the set of values in the subquery result. The assumption is that the subquery returns a single result. This form is however implicitly using tuple comparisons
    
    Parameters:
    propertyNames - The names of the properties to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertiesSubqueryExpression
  - propertiesIn
```
public static Criterion propertiesIn(String[] propertyNames,
                     DetachedCriteria dc)
```
    Creates a criterion which checks that the value of multiple given properties as being in to the set of values in the subquery result. This form is implicitly using tuple comparisons
    
    Parameters:
    propertyNames - The names of the properties to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertiesSubqueryExpression
  - propertiesNotIn
```
public static Criterion propertiesNotIn(String[] propertyNames,
                        DetachedCriteria dc)
```
    Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result. This form is implicitly using tuple comparisons
    
    Parameters:
    propertyNames - The names of the properties to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    PropertiesSubqueryExpression
  - eqAll
```
public static Criterion eqAll(Object value,
              DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - gtAll
```
public static Criterion gtAll(Object value,
              DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is greater-than ALL the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - ltAll
```
public static Criterion ltAll(Object value,
              DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is less-than ALL the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - geAll
```
public static Criterion geAll(Object value,
              DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - leAll
```
public static Criterion leAll(Object value,
              DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - gtSome
```
public static Criterion gtSome(Object value,
               DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - ltSome
```
public static Criterion ltSome(Object value,
               DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is less-than SOME of the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - geSome
```
public static Criterion geSome(Object value,
               DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - leSome
```
public static Criterion leSome(Object value,
               DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - in
```
public static Criterion in(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is IN the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - notIn
```
public static Criterion notIn(Object value,
              DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a literal is NOT IN the values in the subquery result.
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - eq
```
public static Criterion eq(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given literal as being equal to the value in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - ne
```
public static Criterion ne(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given literal as being not-equal to the value in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - gt
```
public static Criterion gt(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given literal as being greater-than the value in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - lt
```
public static Criterion lt(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given literal as being less-than the value in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - ge
```
public static Criterion ge(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the value in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression
  - le
```
public static Criterion le(Object value,
           DetachedCriteria dc)
```
    Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the value in the subquery result. The implication is that the subquery returns a single result..
    
    Parameters:
    value - The literal value to use in comparison
    dc - The detached criteria representing the subquery
    
    Returns:
    The Criterion
    See Also:
    SimpleSubqueryExpression

Class Subqueries

Method Summary

Methods inherited from class java.lang.Object

Method Detail

exists

notExists

propertyEqAll

propertyGtAll

propertyLtAll

propertyGeAll

propertyLeAll

propertyGtSome

propertyLtSome

propertyGeSome

propertyLeSome

propertyIn

propertyNotIn

propertyEq

propertyNe

propertyGt

propertyLt

propertyGe

propertyLe

propertiesEq

propertiesNotEq

propertiesIn

propertiesNotIn

eqAll

gtAll

ltAll

geAll

leAll

gtSome

ltSome

geSome

leSome

in

notIn

eq

ne

gt

lt

ge

le