Thread: 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.

Originally Posted by gangu_d

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.

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.

Don't except us to guess and solve your problem . Kindly pass more details on the issue.