row_number() function

Question

How to use the

row_number

function in a view?

I use it like this:

SELECT 

    ROW_NUMBER() OVER (ORDER BY name ASC), 

    name, family, mobile, tell

FROM  

    dbo.customer

but SQL Server throws this error:

SQL text cannot be represented in the grid pane and diagram pane.

Answer 1

You can use row_number() in a view, but you need to give it a name to use in a view:

SELECT row_number() over (order by name asc) as seqnum,
       name, family, mobile, tell
FROM dbo.customer;

Sign up