w3resource
SQL exercises

SQL Subquery Exercises: Display all the orders from the orders table issued by the salesman 'Paul Adam'.

SQL SUBQUERY: Exercise-1 with Solution

1. Write a query to display all the orders from the orders table issued by the salesman 'Paul Adam'.

Sample table: Salesman


Sample table: Orders


Sample Solution:

SELECT *
FROM orders
WHERE salesman_id =
    (SELECT salesman_id 
     FROM salesman 
     WHERE name='Paul Adam');

Output of the Query:

ord_no	purch_amt	ord_date	customer_id	salesman_id
70011	75.29		2012-08-17	3003		5007

Explanation:

SQL Subqueries: Display all the orders from the orders table issued by the salesman 'Paul Adam'.

Practice Online


Inventory database model

Query Visualization:

Duration:

Query visualization of Display all the orders from the orders table issued by the salesman 'Paul Adam' - Duration

Rows:

Query visualization of Display all the orders from the orders table issued by the salesman 'Paul Adam' - Rows

Cost:

Query visualization of Display all the orders from the orders table issued by the salesman 'Paul Adam' - Cost

Contribute your code and comments through Disqus.

Previous: SQL SUBQUERIES Exercises Home
Next: Write a query to display all the orders for the salesman who belongs to the city London.

What is the difficulty level of this exercise?