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...

What is the difference between HAVING clause and the WHERE
clause?

Answer Posted / srinivas

As per my knowledge WHERE is for conditional retrieving but
we cann't use Average Functions in WHERE clause.
HAVING clause can include AVG Functions.

Is This Answer Correct ?    20 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we backup Active Directory ?

1042


What is PROJECTION Operation?

1021


How many ways to create table-valued functions?

986


How can we get count of the number of records in a table?

954


Can we use pragma autonomous_transaction in trigger?

962


Which language rdl files made of?

130


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1155


What is Cross Join and in which scenario do we use Cross Join?

1013


Do you know what is difference between stored procedure and user defined function?

1091


How to use copy and concatenate commands in SQL?

1141


What is ms sql server reporting services?

1055


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1079


What are the types of sql server?

1052


what is the different types of backups available in sql server? : Sql server database administration

929


How to list all field names in the result set using mssql_field_name()?

914