Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Derived Table query

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

drbethel

Post subject: Derived Table query

Posted: Tue May 18, 2010 5:28 pm

Newbie

Joined: Fri May 07, 2010 4:31 pm
Posts: 3

Hello, I am pretty new to Hibernate and I am trying to run the following query:

Code:

SELECT
    sku
FROM
(select 
    sku
   , avg(net_margin_percent) as nmp
from 
    analytics.projection_by_day
group by 
    sku) tbl1
where 
    tbl1.nmp >=0.39;

Is there an easy way to do this?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum