Count distinct value in HQL.

Count distinct value in HQL.

How do you count distinct value in HQL?

View Answers

June 1, 2012 at 7:08 PM

count(distinct fieldName) returns number of distinct value of the table under specified field name.

Example :

package net.roseindia.main;

import net.roseindia.util.HibernateUtil;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class DistinctCountHQL {
    public static void main(String[] args) {
        SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
        Session session = sessionFactory.openSession();
        String countHql = "Select count(distinct salary) FROM Employee emp";

        Query countQuery = session.createQuery(countHql);

        System.out.println("Number of Employee: " + countQuery.list().get(0));
    }
}

Output:

Hibernate: select count(distinct employee0_.salary) as col_0_0_ from employee employee0_
Number of Employee having distinct salary : 3

Description: This example counts the number of employee having distinct salary by using count(distinct salary).

Ads









Related Tutorials/Questions & Answers:
Count distinct value in HQL.
Count distinct value in HQL.  How do you count distinct value in HQL?   count(distinct fieldName) returns number of distinct value... = sessionFactory.openSession(); String countHql = "Select count(distinct salary
Hibernate Criteria Count Distinct Example
Hibernate Criteria Count Distinct Example  I am learning Hibernate... Criteria Count Distinct. Can anyone tell me the best place to learn Hibernate Criteria Count Distinct? Thanks   Here is an example of Hibernate Criteria
Advertisements
Using Min, Max and Count on HQL.
Using Min, Max and Count on HQL.  How to use Min, Max and Count on HQL
Hibernate Criteria Count Distinct
Hibernate Criteria Count Distinct The Hibernate Criteria count distinct is used to count the number of distinct records in a table. Following a way to use... this application it will display message as shown below: select count(distinct
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1  Column count doesn't match value count at row 1 UPDATE user_profile SET id=[value-1],user_id=[value-2],full_name=[value-3],mobile_phone=[value-4],hide_email_id=[value-5],hide
HQL
HQL  What is the HQL in hibernate ? Explain the use of HQL.   Hi Friend, Please visit on this link....... Hibernate Query Language
Hibernate count() Function
Hibernate count() Function In this tutorial you will learn how to use the HQL.... for example : count( [ distinct | all ] object | object.property) count(*); also...("select count(distinct gd.numOfGoodsOrder) from GoodsDealer gd"
how to find [count the number of integers whose value is less than the average value of the integers]
how to find [count the number of integers whose value is less than the average value of the integers]  Construct an algorithm that will prompt... program is to display the average integer value and the count of integers less
convert into hql
convert into hql   String sqlListSurveys= "select distinct s.surveyAutoID, s.surveyTitle, date(s.modifiedOn) modifiedOn, s.createdOn, " + "( CASE s.surveyState WHEN '0' THEN 'Created' WHEN '1' THEN 'Published
Hibernate Count Query
, they return an aggregate value (such as sum, average, and count) calculated from... of them are self-explanatory. count( [ distinct | all ] object... Hibernate Count Query      
Distinct and Limit example in MySQL
Distinct and Limit example in MySQL  Hi, How to use the distinct... of distinct in SQL select distinct(last_name) from email; select distinct(last_name) from email where email_count >100; Here is example of limit in MySQL
HQL query
HQL query  how to select only password based on username using HQL query from login table where uname and paswrd are two column names
HQL Query
HQL Query  Hibernate query language: How to use a left join in Hibernate query language. Can somebody help with an example. I am getting a unexpected token error in HQL Query tool If I use joins
HQL in hibernate ? Explain the use of HQL.
HQL in hibernate ? Explain the use of HQL.  What is the HQL in hibernate ? Explain the use of HQL.   HQL stands for Hibernate Query...(); Session session = sessionFactory.openSession(); String hql="SELECT
HQL Sample
HQL Sample In this site there are many tutorials and example of HQL. These examples comes with HQL sample code that you can download and run on your computer and learn the HQL by modifying and executing these examples. The HQL Sample
how to convert sql into hql
how to convert sql into hql   StringBuffer questionDataSql = new... distinct q.questionVerbiage, qt.questionType, ") .append("GROUP_CONCAT(distinct ifnull(qo.optionVerbiage,'') order by qo.questionOptionAutoID
HQL order by.
HQL order by.  HQL Order by query giving problem.   Order... into descending order you can follow the following HQL ? String hql="Select emp FROM...(); String hql="Select emp FROM Employee emp ORDER BY name"; Query query
HQL group By.
HQL group By.  How to use group by in HQL?   In general...=sessionFactory.openSession(); String hql="Select emp.name FROM Employee emp GROUP BY name"; Query query=session.createQuery(hql); query.setResultTransformer
SQL SELECT DISTINCT Statement
SQL SELECT DISTINCT Statement       In this example we will show you the usage of Distinct clause with the select statement. The SQL Distinct clause is used with the Select statement
SQL SELECT DISTINCT Statement
SQL SELECT DISTINCT Statement       In this example we will show you the usage of Distinct clause with the select statement. The SQL Distinct clause is used with the Select
SQL Max Count
SQL Max Count       SQL Max Count is used to return the maximum records value of the specified column... 'SQL Max Count'. To elaborate example we create a table 'Stu'. The create table
count in hibernate .
count in hibernate .  How to implements count in hibernate
Hibernate HQL Update
In this section we will discuss HQL update with example
how I do select from select in hql
'a%' order by globalid ) ) where db_id = 259; this is the sql The below hql doesn't work select RN from ( select rownum RN, DBId from ( select distinct p... link: HQL Select Example
What is Hibernate Query Language (HQL)?
What is Hibernate Query Language (HQL)?  Hi, What is Hibernate Query Language (HQL)? thanks
HQL update problem
HQL update problem  public void saveGuest(List<Long> listid) throws HibernateException{ SessionFactory sf... table HQL plz help
ModuleNotFoundError: No module named 'json-mapper-distinct'
ModuleNotFoundError: No module named 'json-mapper-distinct'  Hi...: No module named 'json-mapper-distinct' How to remove the ModuleNotFoundError: No module named 'json-mapper-distinct' error? Thanks   Hi
HQL Between clause, HQL Between example
HQL Between clause example In this tutorial you will learn how to use HQL... and 6. The HQL Between used for this purpose is: // Create HQL Between clause String HQL_QUERY = "select c from Customer c where c.id between 2 and 6"
Delete Query using HQL
Delete Query using HQL  Can we write 'AND' with 'WHERE' clause in delete query using HQL? For example: delete from table name where field1 = value1 and field2 = value2   The example query i have written
HQL, Hibernate Query Language
HQL - Hibernate Query Language In this tutorial on HQL we will learn how to use HQL to perform CRUD operations on the persistence Entity objects. This is complete tutorial on HQL. You will find almost all the topics related to HQL
count the users?
count the users?  how to get the number of users logged in any application

Ads