Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Query to find all cars sold by salesman

This is a discussion on Query to find all cars sold by salesman within the SQL forums, part of the Databases category; 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 ...

Geeks Talk > Databases > SQL Query to find all cars sold by salesman

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   01-04-2008

gangu_d Junior Member   Join Date: Jan 2008 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

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.

Sponsored Links

#2 (permalink)   01-04-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 64 Times in 63 Posts

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 (permalink)   01-05-2008

sreekumar_nair_it Contributing Member   Join Date: Nov 2007 Location: India Posts: 63 Thanks: 5 Thanked 8 Times in 7 Posts

Re: Query to find all cars sold by salesman Quote: 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.

#4 (permalink)   01-08-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

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.

Geeks Talk > Databases > SQL

« Oracle-SQL question | Can Select statement be used along with Update statement? »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query to find structure of a table	Geek_Guest	SQL	12	09-01-2008 11:12 PM
regarding sql query	psuresh1982	SQL	8	07-13-2007 04:20 AM
Query	jescalante	Oracle	4	06-25-2007 03:13 AM
Query	K.K.Rajiv	SQL	2	05-29-2007 11:41 PM
Query with C++	StephenRaj	C and C++	1	08-14-2006 05:09 AM

All times are GMT -4. The time now is 01:03 AM.