Tuesday, September 28, 2010

What is the difference between a “where” clause and a “having” clause in SQL ?

“Where” Clause in SQL is a kind of restiriction statement. You use where clause to restrict all the data from DB.Where clause is using before result retrieving. But Having clause is using after retrieving the data.Having clause is a kind of filtering command from the selected data.

No comments:

Post a Comment