what is difference between having and where clause ?

Answer Posted / anil sharma

Having clause ia used only with group by, and where used with any input type

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use max in where clause?

509


What are tables in sql server?

528


What is ms sql server triggers?

530


Can you pass expressions to function parameters?

532


What is user-defined inline table-valued function?

512






How to use subqueries with the exists operators in ms sql server?

584


What is the difference between an index and a unique index?

544


What are different types of table joins?

555


What is the Difference Between Primary and Foreign Key?

585


Define full outer join in sql server joins?

493


How to retrieve field values using mssql_result()?

626


How can we delete a table in sql server?

550


Can I delete event logs?

541


what are the types of indexes? : Sql server database administration

595


What is the most common type of join?

524