Getting Started with Adobe After Effects - Part 6:
This blog contains various articles on the SQL Server. Also this blog contains various interview questions on the SQL Server. Through this blog I try to make the learning of SQL Server/ BI and SQL DBA very easy and in a quick time.
Browse by Tags ·
Interview Questions on sql server
Happy New Year
Rebuild And Reorganization of Indexes
Replication in SQL Server
Fragmentation in SQL Server
Log Shipping in SQL Server
Technology With Vivek Johari
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a unique key on a table. In these cases we need to find out the duplicate records and need to delete them. We can use the Having Clause to find out that du...
Posted on Nov 15 2010 4:24PM
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there are some differences between them. These difference are given below:- To show the difference between the Where Clause and the Having clause we...
Posted on Jan 31 2010 2:12PM
Group by.....Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns. The syntax of the Group by clause is:- Select column1, column2, column3, aggregate_function(expression ) From TableName Where (condition) ...
Posted on Jan 31 2010 2:11PM
Copyright © Rivera Informatic Private Ltd