/SQL/Create row number in sql

Create row number in sql

Create row number in sql

SELECT t.A, t.B, t.C, ROW_NUMBER() OVER (ORDER BY t.A) as newId
  FROM dbo.tableZ AS t
  ORDER BY t.A;

0

Source: stackoverflow.com

Tsql row number

SELECT 
   ROW_NUMBER() OVER (
 ORDER BY first_name
   ) row_num,
   first_name, 
   last_name, 
   city
FROM 
   sales.customers;

0

Source: sqlservertutorial.net

Similar codes

53 votes643 views6 answers
How to install mysql ubuntu
SQL
0 vote394 views1 answer
Parent and child link in mysql
SQL
0 vote386 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
16 votes339 views2 answers
Add column if not exists mysql
SQL
0 vote322 views1 answer
Partitioning in oracle-base
SQL
0 vote345 views1 answer
SQL division of an integer by another integer get float CAST
SQL
22 votes324 views4 answers
Mysql date format
SQL
0 vote369 views1 answer
How to set up an anonymous function to variable in swift
SQL
4 votes332 views1 answer
T-sql get duplicate rows
SQL
1 vote340 views1 answer
Oracle stop
SQL

Share