Hi,
I have the following query in db2:
"insert into xyz (a,b) select 10, MIN(CM_LEDGERITEM.tril_gid) OVER(PARTITION BY CM_LEDGERITEM.MMPAYEE, CM_PROMOTION.MMCOMPTYPE, CM_LEDGERITEM.MODEL) from ...."
I am not able to find a corresponding thing for min(...) over(partition by col1, col2, col3..)
in postgres.What will be its equivalent in postgres??
Regards, Vinita Bansal
_________________________________________________________________
Manage information better. Optimise your tasks. http://www.microsoft.com/india/office/experience/ Experience MS Office System.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
