---
title: "SQL SELECT Statement 5 Associated Clauses"
description: "The SELECT statement is a powerful and best SQL being used in all data warehousing projects. This SELECT statement contains 5 clauses. To master expert in writing SELECT query you need hands-on how to use these clauses."
url: https://srinimf.com/2017/01/23/tricky-db2-question-on-select-statement/
date: 2017-01-23
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2017/01/pexels-photo-5473010.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["Top 5 clauses you need for SQL SELECT"]
type: post
lang: en
---

# SQL SELECT Statement 5 Associated Clauses

There are total 5 clauses in any standard SQL SELECT statement.Each clause has its own purpose. By reading and hands on these, you will become expert in writing SELECT [SQL query](https://srinimf.com/2013/04/01/db2-raise-error-function/). Really awesome and simplified list. Good for refresh SQL or for ready to use in any project currently you are working in.

Related[How to access “IMS DB” database using SQL Queries(1 of 2)](https://srinimf.com/2015/10/06/how-to-access-ims-db-database-using-sql-queries1-of-2/)

Sorry! This product is not available for purchase at this time.

| 1. SELECT | column name(s)* |
| --- | --- |
| 2. FROM | table or views |
| 3. WHERE | conditions or predicates are met |
| 4. GROUP BY | subsets of rows |
| 5. HAVING | a common condition as a group |
| 6. ORDER BY | a sorting method |

Related posts

- [DB2 – Fetch 1 Row Vs Optimize 1 Row Top Differences](https://srinimf.com/2014/05/02/db2-fetch-queryno-optimize/)DateMay 2, 2014
- [5 More Frequently Asked DB2 SQL Queries](https://srinimf.com/2015/05/15/5-more-frequently-asked-db2-sql-queries/)DateMay 15, 2015
- [20 Top DB2 Frequently Asked Questions](https://srinimf.com/2015/05/10/top-db2-frequently-asked-questions-part1/)DateMay 10, 2015

### 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%2F2017%2F01%2F23%2Ftricky-db2-question-on-select-statement%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2017%2F01%2Fpexels-photo-5473010.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=SQL%20SELECT%20Statement%205%20Associated%20Clauses)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2017/01/23/tricky-db2-question-on-select-statement/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2017/01/23/tricky-db2-question-on-select-statement/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2017/01/23/tricky-db2-question-on-select-statement/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2017/01/23/tricky-db2-question-on-select-statement/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20SQL%20SELECT%20Statement%205%20Associated%20Clauses&body=https%3A%2F%2Fsrinimf.com%2F2017%2F01%2F23%2Ftricky-db2-question-on-select-statement%2F&share=email)
-

### Like this:

Like Loading…