Sql top 10 list inner join by row number

create procedure GetTop10List



as

begin
select top 10 ROW_NUMBER() OVER(order by Kullanici.ID) asSraNo, Kullanici.AdSoyad, kbt.Sure

from Kullanici inner join kbt on Kullanici.ID = kbt.KullaniciId order by BitirmeSuresi asc



end

Yorumlar