Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Regarding Select statement?

Hi All,

i have a table with fields pid,epiid,episrno,serviceid,payserialno,amount,minprice.

pid,epiid,episrno,serviceid these are primary fields.

if minprice = 8000,and the patient had pay like

pid payserialno amount Minprice

A 1 1000 8000

A 2 2000 8000

A 3 4000. 8000

now i have to check the total amount with minprice.how can i get the total amount.

ie sum(amount)>=8000.

ie how can write the SELECT statement?

Regards,

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question