Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.

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 year 2013. I hope this support will continue this year…

0 comments, 81 reads

Posted in Vivek's SQL Notes on 31 December 2013

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 I will tries to show how to delete the duplicate rows using CTE.

Suppose we…

0 comments, 542 reads

Posted in Vivek's SQL Notes on 29 December 2013

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 Chandra Singh
4…

1 comments, 133 reads

Posted in Vivek's SQL Notes on 28 December 2013

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

Abhinav Golwalkar

9 comments, 95 reads

Posted in Vivek's SQL Notes on 28 December 2013

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 Chandra Singh
4…

14 comments, 144 reads

Posted in Vivek's SQL Notes on 25 December 2013

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. For this purpose, SQL server provides us Ranking functions. Ranking…

0 comments, 1,144 reads

Posted in Vivek's SQL Notes on 25 December 2013

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog