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 are the functions in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to make remote connection in database?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is it unwise to create wide clustered index keys?
Why do we use functions?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Explain Reporting Life Cycle?
What is intellisense?
What is a virtual table in sql?
What is the maximum size of column in sql server?
How to specify the collation for a character data type in ms sql server?
how many bits ip address consist of? : Sql server database administration
What are the different types of cursor?
What are the different authentication modes in sql server? How can it be changed?