Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Using Min, Max and Count on HQL

Tags:

hibernate

min

hql

nhibernate

Does hibernate HQL queries support using select min, max, count and other sql functions?

like:

select min(p.age) from person p

Thanks

like image 466
Danmaxis Avatar asked Dec 01 '08 13:12

Danmaxis

People also ask

Can we use select * in HQL?

Keywords like SELECT, FROM, and WHERE, etc., are not case sensitive, but properties like table and column names are case sensitive in HQL.

What is the description for count () in hibernate?

Hibernate Query Language (HQL) supports the following aggregate functions in SELECT statements. Except count() , all other functions except numeric values as arguments. The count() can be used to count any kind of values, including the number of rows in the query result.

1 Answers

Yes, min(), max() and count() are supported in HQL.

see aggregate functions in the Hibernate Doc.

like image 169
Galwegian Avatar answered Nov 10 '22 06:11

Galwegian
Sign in to Comment

Related questions

NHibernate - Execute SQL to populate DTO
NHibernate.MappingException: Could not compile the mapping document
NHibernate mapping not adding ON DELETE CASCADE option to foreign key reference
NHibernate 3.0 configuration with ODP.NET
Nhibernate could not resolve property exception when using QueryOver, works on QueryAll
NHibernate. Order by function result
NHibernate 3.2 By Code ClassMapping for Version Property
a different object with the same identifier value was already associated with the session: 10, of entity: Sales.Entities.Ttable1
How do I setup a ROWVERSION/TIMESTAMP datatype column using FluentMigrator?
How do I do a String.IsNullOrEmpty() test in an NHibernate Queryover where clause?
How to lock objects before update using NHibernate lock modes?
What is the difference between NHibernate.Mapping.ByCode.Conformist.ClassMapping and FluentNHibernate.Mapping.ClassMap?
NHibernate - Force escaping on Table Names
How do I select a Random Row using NHibernate's ICriteria API?
NHibernate QueryOver with ManytoMany
NHibernate QueryOver how to join on non declared relationship
Execute a custom query in nhibernate and map to a custom domain object
NHibernate query strategies in web applications
Encrypting and decrypting data using NHibernate
NHibernate efficiency

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!