SQL Server: Difference between SQL Clause and Statement

This might be a silly discussions on my blog. But some learners like me who are not familiar with English language may get confused between the two. Thus I have posted this article.
As the name implies, SQL Statement is made up of one or more SQL Clauses. To say with an example
SELECT Items FROM inventory WHERE ItemName = 'glasscups' HAVING COUNT(*)>1
The whole content inside the above block is a SQL Statement. Where as SELECT, FROM, WHERE, HAVING are SQL Clauses.

No comments:

Post a Comment