Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects - Part 6:
Motion Blur
Liked
Syndicated Blogs
Upload Image
Close it
Select File
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.
Like
Invite Friends
Browse by Tags ·
View All
CodeProject
6
Sql Server
4
Having Clause
3
Interview Questions on sql server
3
SQLServerPediaSyndication
3
Happy New Year
1
Rebuild And Reorganization of Indexes
1
Replication in SQL Server
1
Fragmentation in SQL Server
1
Log Shipping in SQL Server
1
Archive ·
View All
February 2012
20
December 2012
5
April 2012
4
August 2012
2
November 2010
2
November 2012
1
June 2012
1
May 2011
1
November 2011
1
October 2011
1
Technology With Vivek Johari
Home
·
Most Liked
·
Most Discussed
·
Fans (28)
·
Preferences
1
Liked
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...
Vivek Johari
Posted on Nov 15 2010 4:24PM
Profile
·
Blog
0
Liked
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...
Vivek Johari
Posted on Jan 31 2010 2:12PM
Profile
·
Blog
0
Liked
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) ...
Vivek Johari
Posted on Jan 31 2010 2:11PM
Profile
·
Blog
Copyright © Rivera Informatic Private Ltd
Contact us
Privacy Policy
Terms of use
Report Abuse
Advertising
[ZULU1097]