Preetham Thangamma

Preetham Thangamma

  • 2.1k
  • 167
  • 12k

display premium only for distinct row

May 11 2023 11:32 AM


i have 4 columns in lossrun table in sql server named policynumber,effdate,premium and losstype. My requirement is if there are same values for effdate and policynumber in 3 columns then the premium values has to be dispalyed only for first row and all the remaining rows should display zero.there are 3 columns repeating with the same policynumber and effdate is because of different losstype

Note:the  same effdate and policynumber in single column present having a single losstype should display the premium value as it is. no change in it

thank you


Answers (1)