.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

WHY ALWAYS HAVING CLAUSE SHOULD BE USED AFTER GROUPBY

Posted By: jay     Posted Date: May 04, 2010    Points:2   Category :Sql Server
HI,

WHY ALWAYS HAVING CLAUSE SHOULD BE USED AFTER GROUPBY,

and
inner join why its not good practise to give condition in ON

ex. select fname from tbl1 inner join tbl2
on fname='abc'

above code is not good one...

give some link where i get tips to write optimised SQL code

Responses
Author: diya             
Posted Date: May 05, 2010     Points: 5   

having clause is used to give condition for the groups selected based on a GROUP BY clause



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend