Can Having clause be used without Group by clause?
- 6 Answers
- 41600 Views
- CarrizalSoft Technologies, CSC, CTS, I also Faced
- E-Mail Answers
Answer Posted / anilreddy
No,we can not use.If there is Having it must followed by Group By
| Is This Answer Correct ? | 6 Yes | 52 No |
Post New Answer View All Answers
Explain the different index configurations a table can have?
What is the recommended total size of your memory optimized tables?
What are the differences between having and where clause.
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is the fillfactor concept in indexes?
What is a trigger and its types?
How will you optimize a stored procedure optimization?
Can coalesce return null?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the full form of ddl?
What is the maximum size of sql server database?
How does normalization work?
What is microsoft sql server?
What are the five major components of a dbms?
What is sub query and its properties?
