Query to find all cars sold by salesman
find sales person who sold all car brands in a year
I want to display the sales dealer who sold all the car brands for the present year.
car brand may change year to year ie this may keep on increasing. i like to write a sql query which fetches data without using any hard code values on brand name.
Re: Query to find all cars sold by salesman
Kindly provide table structure , sample data and your required output clearly.
Re: Query to find all cars sold by salesman
[QUOTE=gangu_d;23620]find sales person who sold all car brands in a year
I want to display the sales dealer who sold all the car brands for the present year.
car brand may change year to year ie this may keep on increasing. i like to write a sql query which fetches data without using any hard code values on brand name.[/QUOTE]
Dear gangu_d,
Please provide sample data.
It will be easy for our team members to help you better.
Also send the structure if possible.
Have a pleasant time.
Re: Query to find all cars sold by salesman
Don't except us to guess and solve your problem . Kindly pass more details on the issue.