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 spatial and temporal data?

620


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

596


Explain encryption of entire databases without the need for application changes in sql server 2008?

666


How do triggers work?

613


What are three major types of constraints?

618






Which tcl commands are available on the sql server?

679


How to add code to the existing article (using improve article)?

685


What is 'Join' and explain its various types.

717


What is tempdb database? : SQL Server Architecture

681


What is data source object?

646


Can sub report data source be different from that of the parent report?

115


List the different types of collation sensitivities in sql server?

631


How to turn off warning messages during php execution?

620


What happens if time-only values are provided as date and time literals?

615


How to Insert multiple rows with a single insert statement?

635