how can l get the generic value list order by two filed

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

how can l get the generic value list order by two filed

hzz6222003
Hi, every one
 
the entity modle as follows:
<entity entity-name="Pay" package-name="com.iit.yinshang.order" title="Yingshang payment YLCard pay">
  <field name="orderId" type="id-ne" />
  <field name="amount1" type="currency-amount" />
 <field name="amount2" type="currency-amount" />
  <prim-key field="orderId" />
 </entity>
 
how can l get the rocorders by the following sql:
select * from pay order by amount1+amount2 desc
 
Kind Regards
huang zhong zhou

 
Reply | Threaded
Open this post in threaded view
|

Re: how can l get the generic value list order by two filed

Malin Nicolas