What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?
Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is Redefines clause ? 06.09.08
Redefines clause is used to allow the same storage allocation to be referenced by different data names ....What is File Status in VSAM ? 11.08.08
The FILE STATUS clause of the FILE-CONTROL paragraph allows for each file to be associated with a file status key (i.e., the 2-character data item spec...What is Redefines clause ? 08.08.08
Redefines clause is used to allow the same storage allocation to be referenced by different data names ....What is the difference between DISTINCT CLAUSE and GROUP BY CLAUSE ? 24.07.08
DISTINCT applies to all the fields selected by the query; it retrieves just one (arbitrary) record if there are multiple records with the same values on those f...What is read-only cursor ? 10.04.08
A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword • a UNION o...How do you define a correlated name? 09.04.08
A correlated name can be defined in the FROM clause of a query and in the first clause of an UPDATE or DELETE statement....What is the significance of the CURSOR WITH HOLD clause in a cursor declaration ? 03.04.08
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened....What is the purpose of the finally clause of a try-catch-finally statement? 22.05.07
The finally clause is used to provide the capability to execute code no matter whether or not an exception is thrown or caught....When you use WHERE clause and when you use HAVING clause ? 16.03.06
HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause The WHEREÂ clause is used when you wan...What is the purpose of the finally clause of a try-catch-finally statement? 07.03.06
The finally clause is used to provide the capability to execute code no matter whether or not an exception is thrown or caught....