What is the difference between having and where clause?
- 4 Answers
- 9708 Views
- I also Faced
- E-Mail Answers
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
Explain foreign key in sql server?
Do you know what is a linked server in sql server?
What does it mean if @@cursor_row returns a negative number?
Does any body please help me what question's have asked for SSRS in the interview?
What is difference between view and materialized view?
How to get @@error and @@rowcount at the same time?
Can two tables share the same primary key?
Can you index views?
How to delete an existing database user?
How many types of keys are there?
What is the server name in sql server?
What are the different type of replication in sql server?
Is t sql the same as sql server?
How column data types are determined in a view?
How to configure odbc dsn with different port numbers?
