---
title: "DB2 SQL Query to get row number for project"
description: "In DB2 by writing SELECT SQL query you will not get row numbers in your result. The example SQL query useful for your project to get row numbers in the result."
url: https://srinimf.com/2010/07/04/db2-row-number/
date: 2010-07-04
modified: 2026-10-10
author: "Srini"
categories: ["DB2"]
tags: ["DB2 Tips and Solutions", "SQL Query Row Number"]
type: post
lang: en
---

# DB2 SQL Query to get row number for project

[![DB2 Tutorial](https://i0.wp.com/srinimf.com/wp-content/uploads/2010/07/ipad-816532_640.jpg?resize=191%2C191&ssl=1)](http://srinimf.com/2015/07/13/mainframe-db2-tutorial-for-software-developers-2-of-5/)*DB2 Tutorial*

[https://srinimf.com/](https://srinimf.com/)[2012](https://srinimf.com/2012/01/12/how-to-win-in-2012/)/04/25/db2-built-in-function-count-and-count_big/

In DB2, after fetching rows from a table by using cursor, in [result table](https://srinimf.com/2014/08/05/db2-programming-with-cursors-part1-of-2/) you cannot see row numbers. If there is a requirement in your project you need to see row numbers in the result, then, the below Query is highly useful.

Related[SQL COUNT(*) Vs COUNT(DISTINCT)](https://srinimf.com/2016/03/24/2-key-differences-of-count-and-countdistinct-db2-v11/)

You can get row number by using below SQL query.

Related[DB2 Fetch ideas on how to optimize result](https://srinimf.com/2012/05/02/db2-fetch-rules/)

In [Declare cursor](https://srinimf.com/2012/08/23/pl1-db2-program-coding/), in [SELECT statement](https://srinimf.com/2014/07/09/4-traits-in-db2-cursor-with-hold/) give SQL query as follows:

---

Select row_number over(group by col_1, col_2, col_3)

from table SAMPLE;

---

In the [result table](https://srinimf.com/2015/10/19/differences-of-db2-select-sub-select-and-full-select/) row numbers appears.

In COBOL,DB2 program you cannot see row numbers. This is possible, if you give a query in SPUFI, and you will get row numbers for each row.

### 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%2F2010%2F07%2F04%2Fdb2-row-number%2F&media=https%3A%2F%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2010%2F07%2Fipad-816532_640.jpg&description=DB2%20SQL%20Query%20to%20get%20row%20number%20for%20project)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2010/07/04/db2-row-number/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2010/07/04/db2-row-number/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2010/07/04/db2-row-number/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2010/07/04/db2-row-number/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20SQL%20Query%20to%20get%20row%20number%20for%20project&body=https%3A%2F%2Fsrinimf.com%2F2010%2F07%2F04%2Fdb2-row-number%2F&share=email)
-

### Like this:

Like Loading…