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).









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..._TO_REPLACE_1 for example : count( [ distinct | all ] object | object.property...(distinct gd.numOfGoodsOrder) from GoodsDealer gd"); Iterator count
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
java.sql.SQLException: Column count doesn't match value count at row 1 - JSP-Servlet
java.sql.SQLException: Column count doesn't match value count at row 1  Hi I am trying to put my data into database. But I found the error of : java.sql.SQLException: Column count doesn't match value count at row 1 I
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
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
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      
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
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
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
Hibernate Query Language (HQL)
Hibernate Query Language (HQL)  What is Hibernate Query Language (HQL)?   HQL is much like SQL and are case-insensitive, except... and execute it against underlying database if HQL is used in the application. HQL
count in hibernate .
count in hibernate .  How to implements count in hibernate
SQL Max Count
SQL Max Count       SQL Max Count is used to return the maximum records value of the specified column... an example from 'SQL Max Count'. To elaborate example we create a table 'Stu
Hibernate HQL Update
In this section we will discuss HQL update with example
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
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
Hibernate delete HQL - Hibernate
Hibernate delete HQL  Hi I am trying hibernate tutorial. But delete HQL tutorial not working properly. It gives null pointer exception. Query class has method executeUpate() & not executeUpdate
Hibernate Criteria Distinct
Hibernate Criteria Distinct The Hibernate Criteria Distinct API search and display the distinct result Consider the following SQL SELECT DISTINCT name FROM student WHERE roll_no=2; The above SQL will return the  distinct name
Hibernate-HQL subquery - Hibernate
Hibernate-HQL subquery  Hi, I need to fetch latest 5 records from a table.My query goes here. select * from (select * from STATUS... in HQL which should return list of "Status" type beans.Is it possible?If yes
count the users?
count the users?  how to get the number of users logged in any application
Delete HQL query - Hibernate
Delete HQL query  Hi I am trying hibernate tutorial. But delete HQL tutorial not working properly. It gives null pointer exception. Query class has method executeUpate() & not executeUpdate(); log4j:WARN No appenders
HQL update problem
HQL update problem  public void saveGuest(List<Long> listid) throws HibernateException{ SessionFactory sf... table HQL plz help
Count number of "*"
Count number of "*"  I have this code to count the number of * from...:"); String text = bf.readLine(); int count = 0; for (int i = 0; i...); if (c=='*' ) { count
count characters
count characters  i have to print the total number of char 'A' in all... sabah sarawak terengganu the output must be count the total number of char... main(String[] args) { int count=0; Scanner input=new Scanner
MySQL Count
. It returns a numeric value. If you use COUNT(*) that counts the number of rows.ADS... MySQL Count       This example illustrates how to use count() in MySQL database. Count(): The Count
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
Count Vowels
Count Vowels   Read a string from the user, your program counts the number of vowels in the text and have it report a sum of each vowel found as well as the number of spaces. Make it in two classes
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
HQL Statement: Please help me
HQL Statement: Please help me  Select ProductFamily.* from ProductFamily, ProductGroup, Product where ProductFamily.productFamilyVersionId... = Product.productGroupVersionId and Product.lobId = ? Can you please help me equallent HQL
Hibernate criteria Distinct_Root_Entity Example
Hibernate criteria Distinct_Root_Entity Example  How to create Criteria DistinctRootEntity Example in Hibernate? Thanks   Example program of hibernate criteria DistinctRootEntity. Check the tutorial hibernate criteria
HQL Query in execute method of Struts2
HQL Query in execute method of Struts2  I am making login page in struts2 and using hibernate . Now I wants to pull user name and password from... data from database using hql. And where I need to write the hql query
sentinel value
sentinel value  how to count the number of red cars that assume 10 cars using sentinel value
count objects php
count objects php  How to Count and show objects in PHP
Count Rows - JSP-Servlet
Count Rows  How to count rows in Java. Thanks
sentinel value
sentinel value  how to count the number of red cars. Assume there are 10 cars.   how to count the number of red cars that assume 10 cars using sentinel value
Hibernate criteria count.
Hibernate criteria count.  How do we count rows using criteria in hibernate?   Create hibernate configuration file (hibernate.cfg.xml...(0)); } } Description: Hibernate criteria is used here as alternative to HQL
pie chart flex and sum from hql request
pie chart flex and sum from hql request  hi, i work with flex and j2ee project.i have to make a function wich return list of value: print("public List Statistiqueordinateur() { return template.template.find("select

Ads