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