Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between having and where clause?
- 4 Answers
- 10536 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
Which are new data types introduced in sql server 2008?
What are the properties of sub-query?
Explain about builtinadministrator?
Explain what is meant by replication of database?
What is use of dbcc commands?
How many database files are there in sql server 2000?what are they?
What is sql server used for?
Explain how dts is used to extract, transform and consolidate data?
What is table join?
What are indexes in ms sql server?
Which is faster statement or preparedstatement?
How is sql used in sql server?
What is the difference between delete and truncate statements?
What are the different types of join?
What are various aggregate functions that are available?
