Thank You SirSQL:SELECT SecondLastValue([Place]) AS SLV, Count(1) AS LCountRecords FROM Place_tbl GROUP BY SecondLastValue([Place]);
A last doubt
There are total of 33996 records in Place_tbl
How to get the aggregate of other places in the table with a parameter of <> "Jalna"