query

[mail.divya.k]

NEED TO DISPLAY stdid AND TOPPER IF TOPPER (upper case)IN CLASS(Q1)
and topper in any 1 subject(Q2) ELSE IT SHOULD DISPLAY( lower case)
topper and id

 

[Lynn Trapp]

I'm afraid you are going to have to give us a lot more information before
anyone can give you an answer. Can you post your table structure?

 

[John W. Vinson]

NEED TO DISPLAY stdid AND TOPPER IF TOPPER (upper case)IN CLASS(Q1)
and topper in any 1 subject(Q2) ELSE IT SHOULD DISPLAY( lower case)
topper and id

What color are the walls in my office?

You're assuming that we can see your database, and that we know what TOPPER
and CLASS and so on are. We can't.

Could you give us some help helping you?

John W. Vinson [MVP]