Percentage Query

M

Maria

I have a database which is made up of several tables to show employees, job
titles, and salaries of different divisions within an organisation. I need
a query that will pull on the names of the highest 25% of people with a
certain job title within a table. For example, i would need a query to give
the highest 25% "store workers".

Thanks.
 
J

Jerry Whittle

SELECT TOP 25 PERCENT EmployeeName, Salaries
FROM YourTable
WHERE EmployeeTitle = "store workers"
ORDER BY Salaries DESC;
 
K

KARL DEWEY

made up of several tables to show employees, job titles, and salaries of
different divisions within an organisation.
Your structure seems wrong as you probably should have only one table but
with fields to designate the divisions.
What constitues "highest" when you refer to 'store workers'?

Post sample data with field names and datatype.
 
K

KARL DEWEY

I typed my response wrong ---
Your structure seems wrong as you probably should have only one table but
with A FIELD to designate the divisions.
 
Top