how to get distinct values particular column database

hi

this is post is used people who want to get the distinct values of particulare column like this

sno sname qualification

1     kiran       mca

2  kick            mba

3   kiran        b.tech

now i want to only like this

1 kiran mca

2 kick mba

query is

select min(sno) as id,sname,max(qua) from kiran group by sname