Monthly Archives: December 2013

Happy New Year 2014

                              HAPPY NEW YEAR 2014 Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my blog last … Continue reading

Posted in Miscellaneous | Tagged | 31 Comments

Deleting Duplicate rows using CTE

Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example … Continue reading

Posted in Interview Questions, SQL Advanced, SQL CTE, SQL Server | Tagged | 26 Comments

Answer -Question of the Week – 25/12/2013- Question 1

Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid  Studentname 1               Vivek Johari 2 … Continue reading

Posted in Interview Questions | Tagged | 27 Comments

Question of the Week – 28/12/2013 – Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows contains “Vivek Johari” and the next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari … Continue reading

Posted in Interview Questions | Tagged | 32 Comments

Question of the Week -25/12/2013- Question1

Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid   Studentname  1               Vivek Johari 2 … Continue reading

Posted in Interview Questions | Tagged | 31 Comments

Ranking Functions in SQL Server

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition. For example, suppose we want to give rank to sales man according to their sales amount in a particular month/year. … Continue reading

Posted in SQL Ranking Function, SQL Server | Tagged , | 30 Comments