Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between having and where clause?

Question Posted / honeysukumar

Answers were Sorted based on User's Feedback



What is the difference between having and where clause?..

Answer / thirumal reddy

where clause used to impose conditions in any dml operation
ex:
selct * from emp where empid=10
having clause used to impose conditions on group data
ex:

select sum(sal),avg(sal),count(*) from emp
having avg(sal)>2000

Is This Answer Correct ?    9 Yes 0 No

What is the difference between having and where clause?..

Answer / sd

Where clause operates on the selection before the rows are
actually grouped.

Hence , Try to add as many condition as possible in where
clause instead of having to boost the SQL query performance.

Is This Answer Correct ?    8 Yes 2 No

What is the difference between having and where clause?..

Answer / vinay singh

We can't use Where clause with aggregate function and Having
clause always use with aggregate function.

**Vinay Singh

Is This Answer Correct ?    6 Yes 2 No

What is the difference between having and where clause?..

Answer / kundan ravi

having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is page in sql server?

0 Answers  

How to check parameter value in stored procedure sql server?

0 Answers  

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

what command is used to create a table by copying the structure of another table?

7 Answers  

How to create function without parameter in sql server?

0 Answers  

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

Write a SQL query to delete a table?

0 Answers   Amdocs,

Define clusters?

0 Answers  

What is difference between views and stored procedures?

0 Answers  

Define candidate key, alternate key, and composite key.

0 Answers  

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories