Code For retrieve output with S.No(Serial No. Column) from Sql Table

select ROW_NUMBER() OVER (ORDER BY contact_id) As Sr_No,* from service_provider order by contact_id