what is difference between having and where clause ?
- 3 Answers
- 4981 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
Explain the use of containers in ssis and also their types?
How do clustered indexes store data?
Explain filtered indexes?
What is sleeping status in sql server?
How many tables can be joined in SQL Server?
Can you import Microsoft Excel data to SSRS?
How to disable stored procedure sql server?
What is difference between index and primary key?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the size of transaction log file?
What is query and its types?
Can we write a distributed query and get some data which is located on other server and oracle database?
Can I use sql azure as a backup with log shipping or database mirroring?
What do you understand by the analysis services in sql server?
Explain the truncate command? : SQL Server Architecture
