he ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. Refer to ROW_NUMBER for more information. For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on.You can use ROWNUM to limit the number of rows returned by a query, as in this example:SELECT * FROM employees WHERE ROWNUM < 11;

RowCount gets or sets the number of rows displayed in the DataGridView.Rows.Count returns the number of rows

function will assign a unique number to each distinct row.

Row_Number() function will assign a unique id to each row returned from the query.Rank() function will assign a unique number to each distinct row, but it leaves a gap between the groups.RowCount count the number of row populated by the query.

Row CountThe number of rows that are populated by the Query

Dense_Rank()This function is similar to Rank with only difference.

Rank()This function will assign a unique number to each distinct row.

Row_Number()This function will assign a unique id to each row returned from the query.

ROWNUM - Assign unique row number to each row RANK - Assign number to each row but Rank will be same for rows having duplicate values ROWCOUNT - Return no of rows affected by last query statement