how to display the alerts in table

[geeta_ravikanti]

This is my table

Sno Close1 avg

1 150 110
2 210 175
3 110 150

its my table structure
i am comparing the close1 values with avg values
that is if close1>avg i want to display the message like "Good"
if close1<avg i want diplay the the message like"bad"

my final structure is

Sno Close1 avg result

1 150 110 bad
2 210 175 bad
3 110 150 good


how to write the qery for above table

if any body have idea please tell how to display the messages in table

[sanjeevtarar]

Hello Geeta

do u need a SQL query to update the data in db or something else.?

[geeta_ravikanti]

i want message(good/bad) when the codition is satisfied/not satisfied in the table or i want alert it(good/bad) depends on te codition

[DonCash]

Hello Geeta,

I understand the bit about the good/bad message but are you looking for a SQL query to do this or are you looking to do this in Java?

Do you currently have any code extracting this data from the database?

[geeta_ravikanti]

I want the sql query to display the good/bad when the condtion is satisfied/not satified
any idea