What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / vivek kumar
where clause is used for conditional retriving but having
clause is used to test some condition on the group with the
help of aggregate function.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why is the need for data conversion transformations?
can a table be moved to different filegroup? : Sql server administration
What is log ldf?
What is the stored procedure?
What is the report builder?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How do you check sql server is up and running?
How to change server name in sql server?
How many clustered indexes there can be on table ?
What is an indice?
What is normalization 1nf 2nf 3nf?
Write a query to find 5th highest amount paid from the customer table.
What do you mean by stored techniques? How would we use it?
How to provide values to stored procedure parameters in ms sql server?
Which is the latest version of sql server and when it is released?