Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can Having clause be used without Group by clause?

Answers were Sorted based on User's Feedback



Can Having clause be used without Group by clause?..

Answer / phani

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 ?    72 Yes 16 No

Can Having clause be used without Group by clause?..

Answer / debasish

we can use having clause without group bu clause .but it
will act as where clause

Is This Answer Correct ?    68 Yes 33 No

Can Having clause be used without Group by clause?..

Answer / sumathy

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 ?    30 Yes 3 No

Can Having clause be used without Group by clause?..

Answer / 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

Can Having clause be used without Group by clause?..

Answer / shailesh yadav

Yes HAVING caluse can be use without GROUP BY. the SQL HAVING clause is often used with the GROUP BY clause. If the GROUP BY clause is omitted, the MySQL HAVING clause behaves like the WHERE clause. Notice that the MySQL HAVING clause applies the condition to each group of rows, while the WHERE clause applies the condition to each individual row.

Is This Answer Correct ?    6 Yes 2 No

Can Having clause be used without Group by clause?..

Answer / 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

More SQL Server Interview Questions

What is indexed views? plz explain with example?

2 Answers  


Explain mixed authentication mode of sql server?

0 Answers  


Can you explain various data region available in ssrs with their use?

0 Answers  


how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,


1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  


in how many ways we can use count()

2 Answers  


What is precedence constraint?

0 Answers  


What are Row versions of DataRow?

0 Answers  


two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  


What is a full text index?

0 Answers  


write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,


What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  


Categories