Friday, July 11, 2014

how to generate Serial numbers +Add 1 in select statement sql

SELECT ROW_NUMBER() OVER (ORDER BY ID) AS Id, Question FROM  RiskQuestion WHERE (UserID = " + userId + ")

No comments:

Post a Comment