I have some problem, maybe someone in this forum can solve it.
Let say i have 500 sales records with four salespersons,
SP1= 100 sales records
SP2= 150 sales records
SP3= 175 sales records
SP4= 75 sales records
i want to view all salesperson sales records, but only 20 % sales records based on top sale amount will view each salesperson.
I can view only one by one salesperson and i don't know to view all salesperson. This my syntax :
SELECT HS.BRANCH_ID BRANID,
FROM H_SALES HS,
GROUP BY HS.BRANCH_ID,
ORDER BY HS.SALESMAN_ID,SUM(HS.GROSS_SALES)DESC
>i want to view all salesperson sales records,
>but only 20 % sales records based on top sale amount
>will view each salesperson.
"top sale amount"? Maximum across all sales-critters?
OR maximum per each sales-critter?
What does "will view each salesperson" mean in English?
If/when you can clearly state the problem, you might get some useful suggestions.
For which school, class & instructor is this assignment?