What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / chandra kanth
WHERE is for conditional retrieving and having is using
group of records
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is sql azure database?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What are different replication agents and what's their purpose? : sql server replication
What is merge?
what exactly sql injuction.how to overcome.....
How do I setup a local sql server database?
What is temporary stored procedure?
can SSRS reports Cache results?
What are the approximate numeric data types?
What type of Index will get created after executing the above statement?
What is subquery in sql?
In which files does sql server actually store data?
Explain what is cte (common table expression)?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?