Go to DotNetFunda.com
Home Articles Interview Tips Questions Jokes Resources ASP.NET AJAX Silverlight Links Blog
 Welcome, Guest!  
LoginLogin   		{ Submit content and get exposure !!! }
Submit: Article | Interview Question | Tips | Joke | Question | Link || Search  
 Skip Navigation Links Home > Interview/Exam Questions > what is the diff between a HAVING CLAUSE and a WHERE CLAUSE? ...


.NET Interview Questions

Submit Interview Questions | Search Interview Questions |  Subscribe to RSS
Category .NET Framework | ADO.NET | AJAX | ASP.NET | C# | CSS | Design Pattern and Architecture | F# | HR | HTML, DHTML | JavaScript | OOPS | Others | Remoting, Web Services, XML, XSLT | SQL Server | WCF | WPF | WWF | All |

what is the diff between a HAVING CLAUSE and a WHERE CLAUSE?

Author: Majith | Posted on: 7/24/2008 6:32:47 AM | Category: SQL Server | Views:497 |  Print Asked In: Many Interviews





Answer:
You can use Having Clause with the GROUP BY function in query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.


Interesting?  Bookmark and Share


Navigate to:

<< Previous Interview Question: What’s the difference between // comments, /* */ comments and /// comments?

Next Interview Question >>: How many types of cookies are there in ASP.NET ?

Random Questions: Random Interview Questions

Help: If for some reason you are getting the same question by clicking Next and Previous, Try clicking Random Question or Category link above.


About Us | Contact Us | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
All rights reserved to DotNetFunda.com. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
(Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher)