select siraNo from (select DENSE_RANK() over (order by puan desc) siraNo, ogrNo, ad, soyad, puan from ogrenci) as siraliTablo
where ogrNo=2
$sorgu = select puan,ad from tablo order by puan ASC,ad ASC;
$sira = 1;
foreach($sorgu as $kayitlar){
echo $sira;
echo $kayitlar->ad;
echo $kayitlar->puan;
$sira++;
}