What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / sararh
where clause uesd for the fiend out particulater records and
where clause u write after select statement.
Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the different index configurations a table can have?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is ms sql server service broker?
How to add the custom code in Report?
How can you check the level of fragmentation on a table?
What are the hotfixes and patches in sql server?
What are sql servers used for?
What are the different types of upgrades that can be performed in sql server?
How to create a view on an existing table in ms sql server?
What is history table in sql server?
what happens on checkpoint? : Sql server database administration
What happens when unicode strings concatenate with non-unicode strings?
How to copy data from one table to another table?
what is the difference between openrowset and openquery?