Question: Write a query which will retrieve the values of salesman id of all salesmen getting orders from the customers in orders table without any

Write a query which will retrieve the values of salesman id of

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

Step by Step Solution

★★★★★

3.55 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To retrieve the values of salesmanid of all salesmen gett... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Each team will select a global company and a product or service. The product or service must be something that the select company currently provides, or will provide in the near future. There will...

A bank pays 5% with daily compounding on its savings accounts. Should it advertise the nominal or effective rate if it is seeking to attract new deposits?

Develop an OT table to identify at least five (5) opportunities and five (5) threats that influence the industry and the specific company. Make sure to cite the elements within the table. The OT...

1. Consider the following database Salesman(salesman id,salesman__ name,city,commission) Customer(custamer_id, customer_name,city,grade, calesman_id) Order(order_no, purch_amt, order...

From the following tables write a SQL query to list all salespersons along with customer name, city, grade, order number, date, and amount. Condition for selecting list of salesmen : 1. Salesmen who...

-- DDL for Table CUSTOMERT -------------------------------------------------------- CREATE TABLE "CUSTOMERT" ("CUSTOMER_ID" NUMBER(5,0), "CUST_NAME" VARCHAR2(30), "CITY" VARCHAR2(15), "GRADE"...

Question. Given the structure of inventory database, answer the following: (9*0.5 + 2*0.25 = 5 points) Salesman SALLEMAND NUMERIC (5) VARCHAR(30) WAR (15 DECIMALES CITY customer CUSTOMER O NUMERIC...

Question. Given the structure of inventory database, answer the following: salesman Y SALESMAN_ID NAME CITY COMMISSION NUMERIC (5) VARCHAR 30 ) VARCHAR ( 15 ) DECIMAL(5.2) customer Y CUSTOMER D...

Please write SQL Query Codes for this question . Please write only the sql code not the explanation or any flowchart. Thank you 3. Consider the following schema for Order Database: SALESMAN...

Subject : Database Concept and design Given a database as below: Write a query to the following scenarios: a) Display name and commission for all the salesmen [2 marks] b) Show the winner of the 1971...

What is the difference between earned income and unearned income?

The rocket in vertical flight is being tracked by radar. Calculate the velocity and acceleration of the rocket at the instant when the radar readings are 0 = 40, R=5 km, R = 350m/s, and R =...

10.41 Find v o for the circuit in Fig. 10.86, assuming that v s = [6 cos(2 t ) + 4 sin(4 t )] V. 1+ 250 mF HH 202 ww 10+

Lucky Company's direct labor information for the month of February is as follows: Actual direct labor hours worked (AQ)62,700 Standard direct labor hours allowed (SQ) 65,400 Total payroll for direct...

Derived classes Full time employee with private salary and constructor and getter methods. Part time employee with private daily wage and constructor and getter methods. In the main function, create...

A base class called Shape and derived classes called Circle, Square, and Triangle. In the base class, make a virtual function called draw( ), and override this in the derived classes. Make a pointer...

By using pure virtual functions, create a simple shape hierarchy in C++ that defines a base class called Shape and derived classes called Circle, Square, and Triangle. In the base class, make a...

Select the correct one from the following: 1. An independent CPA is engaged to audit the financial statements of the City of Highland Hills. The City has a variety of revenue sources including a...

Goal: "The client will practice producing /k/ sounds in structured activities for 20 minutes per session." What is missing? Group of answer choices Achievable Time-Bound Relevant Measurable

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

=+58. Explain why it is possible for all the measurements in a given sample to lie within the specification limits and for the same data to yield a nonzero estimate of the proportion of the process...

=+b. Check the chart in part (a) for any out-of-control points. If there are any, eliminate them from the data and reconstruct the s chart. Repeat this process, if necessary, until there are no...

=+56. A manufacturer of dustless chalk monitors the consistency of chalk by running an s chart on the density of chalk in subgroups of size 8. The most recent 24 such subgroups had the accompanying...