Is it possible to add id column just result of sql query

Question

SELECT field1, field2
FROM table 1

How can I add an auto-increment temporary id field to query results?

[this](http://stackoverflow.com/questions/16555454/how-to-generate-auto-increment-field-in-select-query) will help. — Kartikeya Khosla, Mar 03 '16 at 11:30

Rahul Tripathi · Accepted Answer · 2016-03-03T11:48:09.890

5

Try this in MySQL:

SELECT  @s:=@s+1 ,field1, field2
FROM    table1,
        (SELECT @s:= 0) AS s

In MSSQL it would be

SELECT row_number() OVER (ORDER BY field1, field2) n,
       field1, field2 
FROM table1

edited Mar 03 '16 at 11:48

answered Mar 03 '16 at 11:30

Rahul Tripathi

This is fine but as per question the id required is from 0. – SUDARSHAN BHALERAO Mar 03 '16 at 11:41
I am taking syntax error. I am using msSql by the way. – Nuran Yüksekce Mar 03 '16 at 11:42
@NuranYüksekce:- Then why you tagged it as MySQL? Wait I will change it to be MSSQL compliant – Rahul Tripathi Mar 03 '16 at 11:43
@NuranYüksekce:- Check the updated answer. Hope it helps! – Rahul Tripathi Mar 03 '16 at 11:48
1

@SUDARSHANBHALERAO:- The question is updated. Check now! And for starting it from 0 you just have to start from `-1` http://www.sqlfiddle.com/#!9/40198d/4 – Rahul Tripathi Mar 03 '16 at 11:51

1 Answers1