Comparing and return value based on it

Closed
arun - Oct 18, 2011 at 08:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 18, 2011 at 09:39 AM
Hello,
I've got a table in such a way like
Age Age Cost
16 20 3500

like the above i've 1000 rows
i need the O/p as if the age is between the range of the two ages , it must return the value in cost column



1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 18, 2011 at 09:39 AM
Hi Arun,

What is O/p and how to determine the value in the cost column?

Have no idea what you want to achieve.

Best regards,
Trowa
0