hello sir m using bellow query to fetching the record from gridview as per pagesize ..it run succesfully...bt in somewhere in my table cantainig dublicate record so at dt time i wnt to use "distinct "......bt i didnt get how to write query which ll give m exact ditinct record........... m submiting bellow my query
WITH TblRowNum AS(SELECT ROW_NUMBER() OVER (ORDER BY Acadamic_Master.Esrno ASC) AS RowNumber, Employee_Master.Esrno as Esrno ,Employee_Master.EmpId,Empname,Join_Date
From Acadamic_Master left outer join Employee_Master on Acadamic_Master.Esrno=Employee_Master.Esrno
where Isnull(Acadamic_Master.Isdeleted,0)=0 and Not(Isnull(Acadamic_Master.Esrno,0)=0))
SELECT * FROM TblRowNum WHERE RowNumber BETWEEN 1 AND 10 ORDER BY RowNumber ......
Thnx in Advance .....