Explain what is row_number function?
- 1 Answers
- 1125 Views
- I also Faced
- E-Mail Answers
Answer / Manish Asthana
{"ROW_NUMBER() is a window function in SQL Server that assigns a unique number to each row within an ordered result-set.nIt can be used for pagination, record numbering, or rankings.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of constraints?
How to include date and time values in sql statements?
What is difference statement and preparedstatement?
How to find the list of fixed hard drive and free space on server?
What is data source document?
Explain what is the purpose of sql profiler in sql server?
How to Generate a Series of Random Integers With T-SQL?
Explain what are magic tables in sql server?
What is sql server transaction log file?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
what is integrated security (SSPI). why we use in the connection string?
How do you troubleshoot errors in a SQL Server Agent Job?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
