Results 1 to 4 of 4

Thread: Query to find all cars sold by salesman

  1. #1
    Junior Member
    Join Date
    Jan 2008
    Answers
    1

    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.


  2. #2
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Query to find all cars sold by salesman

    Kindly provide table structure , sample data and your required output clearly.

    Last edited by krishnaindia2007; 01-04-2008 at 04:04 AM.

  3. #3
    Contributing Member
    Join Date
    Nov 2007
    Answers
    53

    Re: Query to find all cars sold by salesman

    Quote Originally Posted by gangu_d View Post
    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.


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact