query help

got slightly similar table.
#Temp Table:
name,name1,name2,exam,score
A,A1,A21,
A,A1,A21,math100,88
A,A1,A21,math101,56
A,A1,A21,
A,A1,A21,math102,67
A,A1,A21,
A,A1,A21,math104,45
A,A1,A21,Chm100,55
A,A1,A21,
A,A1,A21,chm101,86
A,A1,A21,chm102,44
A,A1,A21,
(skipping)
A,A1,A22,math100,86
A,A1,A22,
A,A1,A22,math101,99
(skipping)
A,A2,A21,
A,A2,A21,math100,68
A,A2,A21,
A,A2,A21,math101,92
(skipping)

How to select * in case of highest
score and lowest score grouped
by name,name1,name2 where exam
and score are not null
(empty fields)?.

drop Table #Temp

--
Sent by techquest from fastmail subpart from fm
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.comYour question is not clear. Can you tell us that your desired result set is?

Shervin

"techquest@.fastmail.fm" <u753143310@.spawnkill.ip-mobilphone.net> wrote in
message news:l.1066876242.1226959228@.[63.127.215.130]...
> got slightly similar table.
> #Temp Table:
> name,name1,name2,exam,score
> A,A1,A21,
> A,A1,A21,math100,88
> A,A1,A21,math101,56
> A,A1,A21,
> A,A1,A21,math102,67
> A,A1,A21,
> A,A1,A21,math104,45
> A,A1,A21,Chm100,55
> A,A1,A21,
> A,A1,A21,chm101,86
> A,A1,A21,chm102,44
> A,A1,A21,
> (skipping)
> A,A1,A22,math100,86
> A,A1,A22,
> A,A1,A22,math101,99
> (skipping)
> A,A2,A21,
> A,A2,A21,math100,68
> A,A2,A21,
> A,A2,A21,math101,92
> (skipping)
> How to select * in case of highest
> score and lowest score grouped
> by name,name1,name2 where exam
> and score are not null
> (empty fields)?.
> drop Table #Temp
>
>
> --
> Sent by techquest from fastmail subpart from fm
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com