What is the difference between having and where clause?
Answer Posted / thirumal reddy
where clause used to impose conditions in any dml operation
ex:
selct * from emp where empid=10
having clause used to impose conditions on group data
ex:
select sum(sal),avg(sal),count(*) from emp
having avg(sal)>2000
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a mixed extent?
How to configure and test odbc dsn settings?
What is best institute to Learn DotNET And SQL in chennai?
How to apply cascading referential integrity in place of triggers?
What happens if we shrink log file in sql server?
What is sql or structured query language?
How do I create a partition table in sql server?
What is dknf in normalization form?
How to use values from other tables in update statements in ms sql server?
How do I find the port number for sql server?
What is sql server profiler trace data file?
What is de-normalization and what are some of the examples of it?
What is t-sql script to take database offline – take database online.
How to Update from select query in sql server?
What is report snapshot in ssrs?