/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 vote206 views1 answer
Get last three characters in mysql column
SQL
2 votes187 views2 answers
Sql query to copy data from one column to another
SQL
0 vote177 views1 answer
Mod function example
SQL
0 vote219 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
-1 vote191 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote201 views1 answer
Django mssql backend
SQL
0 vote201 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote194 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote186 views1 answer
Like and not like together in sql
SQL
0 vote207 views2 answers
Dbms interview questions
SQL

Share