hibernate subqueries

[rajiv jackz]

Hai to all,

how to perform hibernate subqueries . give me example.

[Paul Sturrock]

As Criteria or HQL?

[rajiv jackz]

HQL and Left join and right join in HQL too.

[Paul Sturrock]

Here you go.

[rajiv jackz]

Thanks ..

I am using displaytag for pagging(pagination )and sum of particular column.

when i give page size it is not showing the total. if I remove the page size it is showing the total of particular column.

hear is my code

<display:table name="${getRevenue}" pagesize="15" export="true" class="simple" decorator="org.displaytag.decorator.TotalTableDecorator" >

<display:column property="revenue" title="Revenue" total="true" />

<display:column property="revenueShare" title="Revnue Share " total="true" /> can you provide solution?