---
title: "Four typical subqueries you need to your project"
description: "Sub queries you can give at four places in main query. Those are SELECT, WHERE, HAVING and in FROM clause. To understand these examples clearly you must listen few tips here."
url: https://srinimf.com/2018/01/23/four-typical-sub-queries-you-need-to-your-project/
date: 2018-01-23
modified: 2026-10-13
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/sub-queries.png?fit=509%2C337&ssl=1
categories: ["SQL"]
tags: ["Example Sub queries for project", "SQL tips and tricks", "Sub queries four types"]
type: post
lang: en
---

# Four typical subqueries you need to your project

You may know that you can use subqueries in the WHERE clause, HAVING clause, FROM clause, and SELECT clause.

Before you read examples…

Listen to my podcast, which tells about some important interview questions on subqueries.

**Example to use a *subquery in the WHERE clause***

Related[Subquery Vs. Correlated Subquery – Top Differences](https://srinimf.com/2012/07/16/sql-sub-query-and-correlated-query/)

```
SELECT
     SalesOrderID,
     RevisionNumber,
      OrderDate
FROM Sales.SalesOrderHeader
WHERE EXISTS (SELECT
       1
       FROM sales.SalesPerson
       WHERE SalesYTD > 3000000
       AND SalesOrderHeader.SalesPersonID
                = Sales.SalesPerson.BusinessEntityID);
```

**Subquery in HAVING clause example**

Related[How to Use Group By and Having in SQL Query: Best Example](https://srinimf.com/2023/05/26/how-to-use-sql-having-clause-correctly-in-sql-query/)

```
SELECT   JobTitle,
         AVG(VacationHours) AS AverageVacationHours
FROM     HumanResources.Employee
GROUP BY JobTitle
HAVING   AVG(VacationHours) > (SELECT AVG(VacationHours)
                               FROM   HumanResources.Employee);
```

**[Sub query](https://srinimf.com/2018/01/21/sub-query-to-return-single-value-example-query/) in FROM clause**

```
SELECT
 x.ProductID,
 y.ProductName,
 x.max_unit_price
FROM (SELECT
     ProductID,
     MAX(UnitPrice) AS max_unit_price
     FROM order_details
     GROUP BY ProductID) AS x
     INNER JOIN products AS y
     ON x.ProductID = y.ProductID;
```

**[Sub query in](https://srinimf.com/2020/02/02/how-to-to-write-sub-query-quickly/) SELECT clause**

```
SELECT DISTINCT
 title_id,
 (SELECT
  au_id
  FROM titleauthors
  WHERE au_ord = 1
  AND title_id = t.title_id)
  AS first_author,
 (SELECT
  au_id
  FROM titleauthors
  WHERE au_ord = 2
  AND title_id = t.title_id)
  AS second_authors,
 (SELECT
   au_id
   FROM titleauthors
   WHERE au_ord = 3
   AND title_id = t.title_id)
   AS third_author
   FROM titleauthors t;
```

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2018%2F01%2F23%2Ffour-typical-sub-queries-you-need-to-your-project%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2018%2F01%2Fsub-queries.png%3Ffit%3D509%252C337%26ssl%3D1&description=Four%20typical%20subqueries%20you%20need%20to%20your%20project)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2018/01/23/four-typical-sub-queries-you-need-to-your-project/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2018/01/23/four-typical-sub-queries-you-need-to-your-project/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2018/01/23/four-typical-sub-queries-you-need-to-your-project/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2018/01/23/four-typical-sub-queries-you-need-to-your-project/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20Four%20typical%20subqueries%20you%20need%20to%20your%20project&body=https%3A%2F%2Fsrinimf.com%2F2018%2F01%2F23%2Ffour-typical-sub-queries-you-need-to-your-project%2F&share=email)
-

### Like this:

Like Loading…