Please use the user forum for such question, thanks.
Boris Shiryov wrote:
Hi, All
How can I use subqueries in the select clause?
SQL query like that:
select
t1.*,
(select count(*) from t2 where t1.id=t2.id_t1)
from
t1
executes faster, than "group by"-styled query from t2, on my SQL server.
But I don't know how I can write such query in HQL.
Only solution that I find is to use: formula="_subquery_" in "property" tag
of
hibernate mapping file.
Boris
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
--
Emmanuel Bernard
[EMAIL PROTECTED]
callto://emmanuelbernard
http://www.hibernate.org
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel