Select distinct mobileno from mobilecollection
count(*) as cnt
select a.*, b.cnt from ..
select a.* from mobilecollection a inner join ( select distinct mobileno, min(id) as id from mobilecollection group by mobileno ) as b on a.mobileno = b.mobileno and a.id = b.id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)