/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

0 vote179 views1 answer
SQL Query to delete all the tables in a database
SQL
6 votes186 views1 answer
Oracle list primary key
SQL
0 vote189 views1 answer
Code to move ietms from one table to another myswl
SQL
2 votes185 views1 answer
Oracle list grants on package
SQL
2 votes149 views2 answers
Mysql get last character of string
SQL
0 vote186 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote176 views1 answer
Sql common columns
SQL
3 votes186 views2 answers
How to open postgresql in windows
SQL
10 votes182 views4 answers
Inner join in update query mysql
SQL
0 vote166 views1 answer
Select password from user mysql
SQL

Share