Write a query which will retrieve the values of salesman id of all salesmen getting orders...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write a query which will retrieve the values of salesman id of all salesmen getting orders from the customers in orders table without any repeats. Sample table: orders ord_no 70001 70009 70002 70004 70007 70005 70008 purch_amt ord_date customer_id salesman__ 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 2012-09-10 3005 2012-07-27 3007 2012-09-10 3002 150.5 270.65 65.26 110.5 948.5 2400.6 5760 5002 5005 5001 5003 5002 5001 5001 Write a query which will retrieve the values of salesman id of all salesmen getting orders from the customers in orders table without any repeats. Sample table: orders ord_no 70001 70009 70002 70004 70007 70005 70008 purch_amt ord_date customer_id salesman__ 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 2012-09-10 3005 2012-07-27 3007 2012-09-10 3002 150.5 270.65 65.26 110.5 948.5 2400.6 5760 5002 5005 5001 5003 5002 5001 5001
Expert Answer:
Answer rating: 100% (QA)
Based on the sample table provided you want to retriev... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these programming questions
-
Because Natalie has been so successful operating Cookie Creations, Katy would like to have Natalie become her partner. Katy believes that together they will create a thriving cookie-making business....
-
Explain relationships between quid pro quo and hostile environment harassment.
-
Gios Restaurants is considering a project with the following expected cash flows: If the projects appropriate discount is 12 percent, what is the projects discounted payback? PROJECT YEAR CASH FLoW...
-
What tax rate is best to use in tax planning? a. Marginal tax rate b. Average tax rate c. Effective tax rate d. None of the these
-
Rouge Valley Golf and Health Club (RVGH) is a public company that operates eight clubs in a large city and offers one-year memberships. Membership provides members with access to golf and the fitness...
-
The brute force algorithm for string matching is given below: ALGORITHM Brute Force String Match(T[0..n-1], P[0..m-1]) //Implements brute-force string matching //Input: An array T[0..n-1] of n...
-
Many processor architectures have a load with post-increment instIt is not possible to implement this instruction without either modifying the register file (adding another write port) or making the...
-
Design a global origin / destination ( O & D ) supply chain model to support production at two new battery production facilities.
-
How does financial organization work? sole proprietorship, partnerships and corporation?
-
Consider the function f(w) = y log((wx)) + (1 y) log(1 (wTx)) Where w and x are kth dimensional vectors. Assume 1 training example. Find Vw,l(w), that is, the partial derivative of (w) with respect...
-
Select information from ADINIKE Corporation's financial statements is provided here. Balance Sheets as of December 31 Current Assets Net Plant and Equipment Total Assets Accounts Payable Notes...
-
write a program in Filter.java will filter an array of integers based on a given command option. Your program will have to support 2 command options and have the described behavior: even - prints out...
-
Q1. Let fn(x) = x^ for all n = N and f(x) = 0. Show that (fn) does not converge uniformly to f on (-1,0). x Q2. Let f (x) = for all n = N and f(x) = 0. n Show that (fn) converges uniformly to f on...
-
A company is a product testing a new medical device. Each day the device is tested on 25 subjects. A QC statistician is hired to calibrate the device so it accurately detects high or low levels of a...
-
You are a U.S. investor who purchased British securities for 2,000 one year ago when the British pound cost U.S. $1.50. What is your total return (based on U.S. dollars) if the value of the...
-
Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.
-
How do you indicate criteria in an Access query?
-
Use a Web browser to find three examples of static Web pages and three examples of dynamic Web pages, and note the URLs for each page you find. Explain the purpose of each page and why you believe it...
-
Using two CST elements, solve the simple shear problem depicted in the figure and determine whether the CST elements can represent the simple shear condition accurately or not. Material properties...
-
A heat conduction problem is modeled using four onedimensional heat conduction elements, as shown in figure 4.6. All elements are of the same length, \(L=1 \mathrm{~m}\), cross sectional area of...
-
Consider a network of onedimensional heat conduction elements as shown in figure 4.7. The temperature at node 1 is fixed and heat inputs at other nodes are prescribed. Properties of the elements are...
Study smarter with the SolutionInn App