Can Having clause be used without Group by clause?
- 6 Answers
- 41602 Views
- CarrizalSoft Technologies, CSC, CTS, I also Faced
- E-Mail Answers
Answer Posted / pradip jain
select max(empno) from dbo.Employee having count(EmpNo)=9
it has no meaning so it will show zero record
| Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
what are the different types of SSRS reports?
Differentiate between SQL and ORACLE joins and write their syntax.
How to create database with physical files specified in ms sql server?
System variable and temporary variables
Why should you use or avoid select * statements?
What do you understand by the denormalisation?
What are the different types of triggers in SQL SERVER?
How to generate create table script on an existing table in ms sql server?
What is ms sql server triggers?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is the difference between ddl,dml and dcl commands?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What are the database objects? : SQL Server Architecture
What is data modeling and Reterminal integrity?
What is parameterized reports in ssrs ?
