---
title: "What is Row_Number()?"  
description: "What is Row_Number()?"  
author: "Amit Singh"  
published: 2011-04-28  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/800/what-is-row_number  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is Row_Number()?

ROW_NUMBER() returns a column as an expression that contains the row’s number within the result set. This is only a number used in the context of the result set, if the result changes, the ROW_NUMBER() will change.

## Answers

### Answer by Amit Singh

ROW_NUMBER() returns a column as an expression that contains the row’s number within the result set. This is only a number used in the context of the result set, if the result changes, the ROW_NUMBER() will change.


---

Original Source: https://www.mindstick.com/interview/800/what-is-row_number

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.