ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Can Having clause be used without Group by clause?
 Question Submitted By :: Madhukar Subbarayan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Can Having clause be used without Group by clause?
Answer
# 1
we can use having clause without group bu clause .but it 
will act as where clause
 
Is This Answer Correct ?    5 Yes 6 No
Debasish
 
  Re: Can Having clause be used without Group by clause?
Answer
# 2
we can use, but select columns and having columns should 
use with aggregare functions

ex:
select max(empid), min(marks)
from employee
having max(empid_id)>100
 
Is This Answer Correct ?    3 Yes 3 No
Phani
 
 
 
  Re: Can Having clause be used without Group by clause?
Answer
# 3
select max(empno) from dbo.Employee having count(EmpNo)=9

it has no meaning so it will show zero record
 
Is This Answer Correct ?    0 Yes 1 No
Pradip Jain
 
  Re: Can Having clause be used without Group by clause?
Answer
# 4
HAVING Clause
Specifies a search condition for a group or an aggregate. 
HAVING is usually used with the GROUP BY clause. When GROUP 
BY is not used, HAVING behaves like a WHERE clause.

Reference:
http://msdn.microsoft.com/en-us/library/aa259187
(SQL.80).aspx
 
Is This Answer Correct ?    0 Yes 0 No
Sumathy
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Which databases are part of SQL server default installation? Explain the usage of each? Accenture2
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me. 247Customer1
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
What are the steps you will take, if you are tasked with securing an SQL Server? HCL1
what is maximum size of temp db? iSoft4
how to generate XML out of QUERY? McAfee1
what is the purpose of creating view is sql server 2000 Wipro9
What are the OS services that the SQL Server installation adds?  1
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
What is Files and Filegroups in SQL Server & it's implementation. Zenith1
If there is failure during updation of certain rows, what will be the state?  1
create index a on employee(dno) In this,which index was created?  2
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ? Perot-Systems8
What is the use of CASCADE CONSTRAINTS?  2
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?  1
Differnce between sel server 2000 and 2005  3
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies12
How to list all tables having unique constraints in any of the columns in a database.  1
Which is best Subquery (or) joins in sql server? explain why  2
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com