help with SELECT

Hi,

Assuming a table looks like this:

ID grade1 grade2 grade3

001   65          52       0
002   70          88       93
003    0           78       0
004    0            0        0

How should I construct a SELECT statement to retrieve those IDs whose non-zero grades are all above 60? In this specific case, the expected result should be 002 and 003.

Appreciate any help.

Bing Received on Tue Oct 16 2001 - 15:51:34 CDT