[Hibernate-issues] [Hibernate-JIRA] Created: (HB-1563) column alias

[Nithya P. (JIRA) <no...@at...>]

column alias
------------

         Key: HB-1563
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-1563
     Project: Hibernate2
        Type: Bug

 Environment: Hibernate 2.0, Cloudscape 
    Reporter: Nithya Priya


Hi,
I have a table that contains 2 columns course_id and  sbu, if I want  to take the max of the count of course_id
using a simple sql query I can use
select max(cnt)  from (select count(course_id) cnt from table group by course_id)
but if I use HQL its giving me query exception if I try to use an alias(cnt in the above case) for the column. Is there any other solution for this problem???
Thanks in advance


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira