WITH TEMPTABLE AS
(
SELECT
ROW_NUMBER() OVER(ORDER BY SchoolId,StudyingClass,AadhaarUID) RowNum,
StudyingClass,SchoolId,
AadhaarUID, StudentId, StudentName, FatherName, MotherName, SurName, Habitation,
DOB, GenderId, SocialCatId, ReligionId, AcademicYear, DOA, GRNo, BPL, Disadvantaged
FROM
dbo.VIEW_SELECT_ALL_SCHOOLS_WITH_STUDENT_DETAILS
WHERE SchoolId=24010100101
)
SELECT * FROM TEMPTABLE
it gives result like
RowNum StudyingClass SchoolId AadhaarUID StudentId StudentName FatherName MotherName SurName Habitation DOB GenderId SocialCatId ReligionId AcademicYear DOA GRNo BPL Disadvantaged
1 1 24010100101 240101001011210001 1423397 FARUK IBRAHIM JALABAI KER GRAMY 2006-10-10 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 339 2 2
2 1 24010100101 240101001011210002 1423679 MOHAMADMINAJ ABDUL NIYAMAT KER GRAMY 2006-11-15 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 340 2 2
3 1 24010100101 240101001011210003 1423942 KHAMISHA HUSEN MARIYA MUNJAVAR GRAMY 2005-04-01 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 341 1 2
4 1 24010100101 240101001011210004 1424374 AJIM IBRAHIM KARIMA PADIYAR GRAMY 2005-12-22 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 342 1 2
5 1 24010100101 240101001011210005 1424681 MAMADMINAJ HAJI KHATABAI PADYAR GRAMY 2005-10-10 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 343 2 2
6 1 24010100101 240101001011210006 1424917 IRAFAN HASAM JENABAI PADYAR GRAMY 2006-12-25 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 344 1 2
7 1 24010100101 240101001011210007 1425223 KONTIBHAI MAGA SAVITA KOLI GRAMY 2006-09-19 00:00:00 1 4 1 2012-13 2012-06-15 00:00:00 345 2 2
8 1 24010100101 240101001011210008 1425495 AESHAN KHAMISHA HULIMA PADYAR GRAMY 2006-12-28 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 346 1 2
9 1 24010100101 240101001011210009 1425821 IRFAN MIRHUSEN NIYAMAT PADYAR GRAMY 2007-06-02 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 347 2 2
10 1 24010100101 240101001011210010 1426171 ALTAF HUSEN ASHIBAI PADYAR GRAMY 2005-09-27 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 348 1 2
11 1 24010100101 240101001011210011 1426532 BHACHAYA AMADH MARIYA PADYAR GRAMY 2003-10-01 00:00:00 1 1 2 2012-13 2012-06-15 00:00:00 361 2 2
12 1 24010100101 240101001011220012 1426821 JAMILA ALI SARIFA KER GRAMY 2007-06-05 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 349 2 2
13 1 24010100101 240101001011220013 1427285 NASIMA AMADHA SHERBANU KER GRAMY 2006-09-04 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 350 2 2
14 1 24010100101 240101001011220014 1427626 NASIMA ABAS SHAKINA KER GRAMY 2006-11-16 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 351 2 2
15 1 24010100101 240101001011220015 1427821 NURBANU KASAM JENABAI KER GRAMY 2006-11-20 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 352 1 2
16 1 24010100101 240101001011220016 1428108 FATMA MAMAD SHAKINA SHEKH GRAMY 2007-02-20 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 353 1 2
17 1 24010100101 240101001011220017 1428375 HAMADHA RAMADHAN ASHIBAI KER GRAMY 2006-02-05 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 354 2 2
18 1 24010100101 240101001011220018 1432690 SHEHNAJ KHAMISHA NIYAMAT KER GRAMY 2007-05-01 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 355 1 2
19 1 24010100101 240101001011220019 1433076 SAIDHABANU MUBARAK ROMABAI PADYAR GRAMY 2005-10-20 00:00:00 2 2 2 2012-13 2012-06-15 00:00:00 356 1 2
20 1 24010100101 240101001011220020 1433377 SHAYANA HUSEN ASHIBAI PADYAR GRAMY 2007-03-01 00:00:00 2 2 2 2012-13 2012-06-15 00:00:00 357 1 2
21 1 24010100101 240101001011220021 1433667 JAMILA AAMADH MARIYA PADYAR GRAMY 2007-02-03 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 358 2 2
22 1 24010100101 240101001011220022 1433994 NIYAMAT ISHAK KHATABAI PADYAR GRAMY 2007-05-25 00:00:00 2 1 2 2012-13 2012-06-15 00:00:00 359 1 2
23 1 24010100101 240101001011220023 1434453 SHABANA JUMA JAINABAI PADYAR GRAMY 2006-12-25 00:00:00 2 1 2 2012-13 2012-06-16 00:00:00 365 1 2
24 1 24010100101 240101001011220024 1434722 FAKUBAI HUSEN MARIYA MINJAVAR GRAMY 2005-10-02 00:00:00 2 1 2 2012-13 2012-07-03 00:00:00 369 1 2
25 2 24010100101 240101001010920001 1435269 ROSHANBAI OSMAN HEDHAYAT PADYAR GRAMY 2003-10-10 00:00:00 2 1 2 2012-13 2009-06-19 00:00:00 286 1 2
26 2 24010100101 240101001010920002 1435540 JAMILA KHAMISHA NIYAMAT KER GRAMY 2003-06-20 00:00:00 2 1 2 2012-13 2009-06-19 00:00:00 288 1 2
27 2 24010100101 240101001010920003 1435748 MINABEN RANA RAJBAI KOLI GRAMY 2004-01-26 00:00:00 2 4 1 2012-13 2009-06-19 00:00:00 289 1 2
28 2 24010100101 240101001010920004 1435998 JENABAI HUSEN ROMATBAI KER GRAMY 2003-06-11 00:00:00 2 1 2 2012-13 2009-06-19 00:00:00 293 1 2
29 2 24010100101 240101001011010001 1443089 ALIASGAR URAS JANATBAI KER GRAMY 2004-11-02 00:00:00 1 1 2 2012-13 2010-06-18 00:00:00 311 1 2