What are the differences between “row_number()”, “rank()” and “dense_rank()”?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain what is cte (common table expression)?

0 Answers  


what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,


What is transact-sql language?

0 Answers  


What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,


As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,






While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  


If no size is defined while creating the database, what size will the database have?

0 Answers  


How to query multiple tables jointly?

0 Answers  


What is the difference between substr and charindex in the sql server?

0 Answers  


How do I schedule a sql server profiler trace?

0 Answers  


How to connect php with different port numbers?

0 Answers  


What command is used to create a database in the sql server and how?

0 Answers  


Categories