A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
Rows count in hql
Joined: Sep 13, 2005
Sep 14, 2005 06:09:00
I am trying to retrieve the number of rows returned with out retrieving the data, can anyone help me how to do this.
I tried some thing like this
select count(*) from table11 join.. where ....
Usually select .. from ... returns a list but I need the result into an int variable which gives me the number of rows with out bringing in the rows.
Joined: Feb 08, 2004
Sep 14, 2005 09:53:00
Usually select .. from ... returns a list
Joined: Aug 24, 2005
Sep 14, 2005 19:14:00
See the Hibernate Documentation
It is sorta covered in the
JavaRanch Style Guide
subject: Rows count in hql
How to find no of Rows in my ResultSet
How to obtain a database table size?
what does "SELECT count(*) from Tablename" mean
how to write this query... count, unique, ??
how to count rows
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015