Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between having and where clause?
- 4 Answers
- 10558 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 the dbcc pintable command when would you use it?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is sql server query analyzer?
What is the sql case statement used for? Explain with an example?
What is sql server replication? : sql server replication
What is the maximum row of a size?
What is shrink log file?
What is triggers and stored procedures?
optimization techinques
Explain the use of containers in ssis and also their types?
What are null values in ms sql server?
What is the server name for sql management studio?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Should you normalize audio?
What is the difference between a view and a stored procedure?
