What are the differences between “row_number()”, “rank()” and “dense_rank()”?
- 0 Answers
- 714 Views
- I also Faced
- E-Mail Answers
More SQL Server Interview Questions
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are cursors?
how many instance use in sql server 2005
What is the query optimization statistics?
Is a primary key unique?
What is the difference between a stored procedure and a user defined function?
How to create database with physical files specified in ms sql server?
How to override dml statements with triggers?
What is MSDE?
How to optimize stored procedures in sql server?
How does index makes search faster?
Why would you use sql agent?
Categories
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
