Explain ranking functions?


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

Post New Answer

More SQL Server Interview Questions

Which language is supported by sql server?

0 Answers  


When is the use of update_statistics command?

0 Answers  


How to convert binary strings into integers in ms sql server?

0 Answers  


How can a user-defined datatype be created?

0 Answers  


Which table keeps information about stored procedures?

0 Answers  






Create and insert into temp table in sql server?

0 Answers  


Mention a few common trace flags used with sql server?

0 Answers  


Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,


What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,


What are subqueries in sql server? Explain its properties.

0 Answers  


How to execute multiple stored procedures at one time in sql server?

0 Answers  


What is use of except clause? How does it differ from not in clause?

0 Answers  


Categories