Stack Overflow
Stack Overflow

Questions tagged [row-number]

An index or rank which indicates a row's position in a data-set.

When referring to multiple rows of information, generally drawn from a database, the row-number refers to the ordinal position at which a specific row of information exists within a given data-set.

Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

Row number function implementations exist in multiple SQL variants, such as Oracle, TSQL and MySQL.

ROW_NUMBER is an analytic function. It assigns a unique number to each row to which it is applied (either each row in the partition or each row returned by the query), in the ordered sequence of rows specified in the order_by_clause, beginning with 1.

1205 questions
-3
votes
2 answers

Sql Server Alias name in Row_Number function

select tmp.id, tmp.portfolio, ROW_NUMBER() OVER(order by tmp.id DESC) AS RowNum from (select r.portfolio, r.id from research r where r.created_by = 'Adam Cohen' ) as tmp WHERE RowNum BETWEEN 5 AND 10; I am not able refer the RowNum…
Vijay VSTO
  • 133
  • 1
  • 4
  • 15
-3
votes
1 answer

Dynamic Identity based on value of other column

I am Creating a table such as student name, class ,roll no roll no is set as identity,information of student is being saved in on table such as student name,class,roll no i want such that Student Name Class Roll No Snehal 1 1 …
Kunal Choudhary
  • 5
  • 3
-4
votes
1 answer

'ROW_NUMBER' is not a recognized function name

My query: select row_number() over(partition by line_no order by line_NO) as orce from tx_hsa_summ This is my query when ever I use the over function I keep getting this error Msg 195, Level 15, State 10, Line 1 'row_number' is not a…
sentil kumar
  • 97
  • 2
  • 7
-4
votes
1 answer

How to get a row number from a table in SQLite

How can I learn whether a particular name is present in my table, and and in which row (row number) it is present?
Mohamed Hisham Ibn Hanifa
  • 3,986
  • 2
  • 15
  • 12
-5
votes
1 answer

Conditional ROW NUMBER to create a Column in SQL

I have two columns ID and FLAG as : ID FLAG 1 Y 1 N 1 Y 1 N 1 N 1 N 1 N 1 Y 1 N 2 N 2 Y 2 N 2 N 2 Y 2 Y 2 N Required Output: ID FLAG REQ_COL 1 Y null 1 N 1 1 Y null 1 N 1 1 N …
Anuranjan Chauhan
  • 1
  • 2
1 2 3
…
80
81