Solved Search last word in a string (1 Viewer)

[nirmal]

SELECT
    SecondLastValue([Place]) AS SLV,
    Count(1) AS LCountRecords
FROM Place_tbl
GROUP BY SecondLastValue([Place]);

Thank You Sir
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"

 

[Eugene-LS]

How to get the aggregate of other places in the table with a parameter of <> "Jalna"

SELECT 
        SecondLastValue([Place]) AS SLV, 
        Count(1) AS LCountRecords
FROM Place_tbl
GROUP BY SecondLastValue([Place])
HAVING Not SecondLastValue([Place])="Jalna";

 

[nirmal]

SELECT
        SecondLastValue([Place]) AS SLV,
        Count(1) AS LCountRecords
FROM Place_tbl
GROUP BY SecondLastValue([Place])
HAVING Not SecondLastValue([Place])="Jalna";

Sir actually I require a total count of rest other than Jalna

 

[Eugene-LS]

Sir actually I require a total count of rest other than Jalna

SELECT Count(1) AS LCountRecords
FROM Place_tbl
WHERE (((SecondLastValue([Place]))<>"Jalna"));

 

[nirmal]

SELECT Count(1) AS LCountRecords
FROM Place_tbl
WHERE (((SecondLastValue([Place]))<>"Jalna"));

Thank You Sir
Getting all the expected results