What is the difference between HAVING clause and the WHERE
clause?

Answer Posted / ishika

Having clause works on recordset while Where works on
individual record

Is This Answer Correct ?    15 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What’s the distinction between dropping a info and taking a info offline?

598


Do you know sql server 2008 introduces automatic auditing?

517


What is a rollup clause?

547


What do you understand by intent locks?

577


Explain collation?

625






Explain about unique identifier data type in sql server?

515


How to create user defined functions with parameters?

644


Explain steps of normalization?

527


What are sql azure firewall rules?

85


What is star, snowflake and star flake schema? : sql server analysis services, ssas

663


Explain how many types of relationship?

577


What is RMS migrations?

1708


Can we perform backup restore operation on tempdb? : sql server database administration

587


Explain powershell included in sql server 2008?

617


What are key, name and value columns of an attribute? : sql server analysis services, ssas

574