What is the use of partition by in sql server?


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

Post New Answer

More SQL Server Interview Questions

A trigger can reference objects outside the current database? State true or false.

0 Answers  


How to how to convert numeric expression data types using the convert() function??

0 Answers  


Explain what are commit and rollback in sql?

0 Answers  


What is exclusive locks?

0 Answers  


What are policy management terms?

0 Answers  






How do I start and stop sql server?

0 Answers  


what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,


what do you understand by change data capture?

0 Answers  


Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  


What triggers long term care?

0 Answers  


How to maintain a fill factor in existing indexes?

0 Answers  


Please differentiate between a local and a global temporary table?

0 Answers  


Categories