sql - Find minimum value of a table -

i'm looking statement find user minimum value of special field. mean this

select id, username, joindate, min(score)  table1 

actually i'm looking way find user lowest score.

to find user lowest score, can simpy sort table , take first record:

select top 1 id, username, joindate, score table1 order score