What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

Answer Posted / santosh pashupatimath

Having clause is used before aggregation and where clause is
used before aggregation

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transact-sql language?

574


Define a cross join?

594


Which data type columns are the best candidates for full-text indexing?

598


What is subquery? Explain the properties of a subquery?

507


Can we linked SharePoint to a SQL database?

587






What are the properties and different types of sub-queries?

558


What are the different sql server versions?

515


How the authentication mode can be changed?

604


What is the data type of time?

513


What are the events recorded in a transaction log?

506


What is the syntax for encrypting a column in SQL Server?

551


What is always encrypted?

516


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

87


Explain can you implement data mining in ssrs?

106


Can we add our custom code in ssis?

542