Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29665 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / swati mandve
where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is full outer join in sql server joins?
What action plan is preferred if sql server is not responding?
Distinguish between commit and rollback?
How to delete an existing row with delete statements in ms sql server?
How to create a new schema in a database?
What is use of except clause?
What is the difference between a view and a stored procedure?
Can sql servers link to other servers like oracle?
How many databases instances are there in sql server 2000?
how many type of indexing in database?
Explain indexes disadvantages?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
If a table does not have a unique index, can a cursor be opened on it?
Write the syntax for stuff function in an sql server?
What is the Main Difference between ACCESS and SQL SERVER?
