Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19607 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / samar
hi i had tried same but i am getting error
Server: Msg 195, Level 15, State 10, Line 1
'row_number' is not a recognized function name
here querry is
select row_number() over(order by Income_Verification_id
) from Dim_Income_Verification
plz reply !!
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
How to use clusters?
what is the system function to get the current user's user id? : Sql server database administration
What are the different types of data sources in ssrs?
What is query optimization process?
Describe in brief system database.
What is meant by referential integrity?
How to convert numeric expression data types using the cast() function?
What are dml triggers and types of dml triggers?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What is table valued function and scalar valued functions?
Write a sql query to get zero records from a table having n number of records?
List types of tables in SQL Azure?
What are the advantages of using third-party tools?
What are different types of roles provided by ssrs?
What are the commands used in DCL?
