Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5573 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhiman
Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
whats new about truncate in sql server 2008?
Explain error handling in ssis?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Can you edit the .rdl code associated with a linked report?
When does a workload on SQL Azure get throttled?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Why use identity in sql server?
Explain the creation and execution of a user-defined function in the sql server?
What is global temp table?
what are the different types of SSRS reports?
How to convert binary strings into integers in ms sql server?
What are the advantages of passing name-value pairs as parameters?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What are rest-style architecture's?
