Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Hibernate Count distinct value in HQL.

Have Programming Question? Ask it here!
 
 
 


ratna rathor
Count distinct value in HQL.
1 Answer(s)      a year and 11 months ago
Posted in : Hibernate


How do you count distinct value in HQL?


Advertisement
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
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
Using Min, Max and Count on HQL.
Using Min, Max and Count on HQL.  How to use Min, Max and Count on HQL
HQL
HQL  What is the HQL in hibernate ? Explain the use of HQL.   Hi Friend, Please visit on this link....... Hibernate Query Language
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
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"
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
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
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 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
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 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
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 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
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
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 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
Hibernate HQL Update
In this section we will discuss HQL update with example
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_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
What is Hibernate Query Language (HQL)?
What is Hibernate Query Language (HQL)?  Hi, What is Hibernate Query Language (HQL)? thanks
count in hibernate .
count in hibernate .  How to implements count in hibernate
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
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
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
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
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
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 Result Example
hibernate criteria Distinct Result Example In this Example, We will discuss... Restriction  and like condition. The DISTINCT_ROOT_ENTITY field is ensures that each row of results is a distinct instance of the root entity. Here is the simple
hibernate criteria Distinct_Root_Entity
hibernate criteria Distinct_Root_Entity In this Tutorial, We will discuss... Restriction  and like condition. The DISTINCT_ROOT_ENTITY field is ensures that each row of results is a distinct instance of the root entity. Here is the simple
count the users?
count the users?  how to get the number of users logged in any application
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
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 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
MySQL Count
. It returns a numeric value. If you use COUNT(*) that counts the number of rows.  ... MySQL Count       This example illustrates how to use count() in MySQL database. Count(): The Count
sum and avg function using HQL.
sum and avg function using HQL.  How to use sum and avg function in HQL?   HQL supports many aggregate functions. Sum and avg are some of them. sum() function returns summation of specified field in the table
Hibernate Named HQL in Annotation
In this section, you will learn how to execute Named HQL written in Model class Annotation
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
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
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
Hibernate Named HQL using XML Mapping
In this section, you will learn executing Named HQL written in XML Mapping file
SQLl query count and group by
SQLl query count and group by  How to write a sql query to count and group by the data?   Sql query to count the data and group the data using group by function... Select Name, Count(Name) As Count From Table Group
Advertisements
 

 

 

DMCA.com