(Sorry, Couldn't find a pure SQL newsgroup)

This little request is working OK.
The idea is to get a percentage of the selected records based only on
the number of records per group
divided by
the number of selected records.
(i.e. NOT divided by the total number of records in the table.)
----------------------------
SELECT
locality,
count(*) as ctr,
count(*) * 100.00 /(SELECT count(*) from pat where locality like 'Pari%')
as percent
FROM Clients
WHERE locality like 'Pari%'
GROUP BY locality
ORDER BY percent desc
----------------------------
But ...
Is there another way of doing it that eliminates using of the where
locality like 'Pari%' clause, twice ?

TIA
Ororft

orofgggghtyy wrote:
I can't think of a way.

Since the WHERE clause appears in two SELECT statements against two
different tables, I doubt that it can be done.

Is this a question about aesthetics or is there another problem
with the query as it is?

Yours,
Laurenz Albe