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 a HAVING CLAUSE and a WHERE
CLAUSE?

Answer Posted / sararh

where clause uesd for the fiend out particulater records and
where clause u write after select statement.

Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain why variables called the most powerful component of ssis?

1171


explain extended properties

1036


What do you understand by coalesce in sql server?

1125


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1073


What is a constant or literal in ms sql server?

1096


Where can you find the error log information? : sql server database administration

1068


Explain about extended stored procedure?

991


Explain about temporary stored procedure?

1091


What are the purposes and advantages stored procedure?

1011


What is a benefit of using an after insert trigger over using a before insert trigger?

1029


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1176


what is denormalization and when would you go for it? : Sql server database administration

1257


Explain data warehousing in sql server?

1088


How do you size a resultset?

961


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1211