What is ROWNUM, RANK and ROWCOUNT ?

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.

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;

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 Count The 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