Loading

Get Only the First Row Value, the Rest should be 0

Jes Sie

I have this query below that gives me row values. I need to get only the first sum_insured value. The rest of the rows should be 0. How will I do that? See the image below:

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajesh Gami4y ago
First, you have to use CTE(Common table expression) with row number and then add a condition with row number.

Check this CTE example with row number
https://stackoverflow.com/questions/7436732/cte-row-number-and-rowcount
0
Rajanikant Hawaldar4y ago
Add if and else condition will resolve your issue else part assign 0
0