If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

if you notice on the 8 and 9th rows the only difference between them is in
the e column(0 and 1). What I am trying to do here is to display all with
max(e). So in the above example, I should display rows 1-7,9,10 (8th row
will not display because the 9th row has 1 in the e column). this is the
query I have been using on SQL Server 2000 but I keep on displaying all the
rows: