Dear SSC Journeyman

thank you for your quick response.

i actually want to show a report which will publish in facebook

the main application is deal with SMS quiz competition and all quiz participant's detail result (total question, total time, total score and participant's mobile no) store in a table dbo.tbl_FaceBookScore.

so my requirement is to publish only one TOP scorer in every group (Quiz_No) who score highest in the shortest time. by default 10 question will sent to every participant one by one. and time count by minute.

thankyou your quick response. it helps me lot. i used you query and make something changes and so i get my desire result.

SELECT a.Quiz_No,a.Mobile_No,a.Score,a.TotalTime,a.TotalQuestion

FROM dbo.tbl_FaceBookScore a

WHERE a.Score =

( SELECT TOP 1 y.Score FROM dbo.tbl_FaceBookScore y

WHERE y.Quiz_No = a.Quiz_No ORDER BY y.Score DESC

) AND

a.TotalTime =

( SELECT TOP 1 z.TotalTime FROM dbo.tbl_FaceBookScore z

WHERE z.Quiz_No = a.Quiz_No AND z.Score = a.Score

ORDER BY z.TotalTime ASC )

ORDER BY a.Quiz_No DESC, a.TotalTime ASC, a.Score DESC

thank you once again Mr. SSC Journeyman

Regards

imneaz