Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between having and where clause?
- 4 Answers
- 10701 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
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Explain about Normalization?
What is the user of Primary key?
What is the usage of the sign function?
Can you please explain the difference between function and stored procedure?
what is difference between view and Dip.
what is a self join? : Sql server database administration
What do you mean by a dependent functionality in a build?
Can you type more than one query in the query editor screen at the same time?
Explain triggers in sql?
When I delete any data from a table, does the sql server reduce the size of that table?
What is the difference between system objects and user objects?
Where in ms sql server is ’100’ equal to ‘0’?
Explain primary key and foreign key constraints?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
