interview

home / developersection / interviews / difference between a "where" clause and a "having" clause.

Ask Question
Chris Anderson

Chris Anderson

Follow

hi I am software developer at mindstick software pvt. ltd.

Can you answer this question?
Answer

1 Answers

Chris Anderson

Chris Anderson

13-Sep-2011
Having clause is used only with group functions whereas Where is not used with.

RELATED FORUMS

Return Top Five Recodrs From Table

Alter Table

Difference between stored procedure and function?

Stored Procedure RETURN DataType

Convert VarChar to DataTime

RELATED BLOGS

Constraints in SQL

Triggers in SQL

SQL Joins

Cursor in SQL

Indexes in SQL

RELATED ARTICLE

Use of DML, DLL and logon trigger in SQL

SQL Server 2017 CTP 2.0 Now Available

Union Example in SQL Server

Database Mail in SQL Server

Pivot with Dynamic columns in SQL Server

YourViews

Islamic Terror Attack in Kashmir, Pahalgam

As Indians, are we losing our culture? True?

10 Science-Based Benefits of Yoga

Why Samajwadi Party always support goons and criminals?

Is Mamata Banerjee a threat to India? We must know.

Question & Answer

What are the key factors influencing the growth and pricing trends in the global cocoa market?

Are harsher punishments more effective than rehabilitation in deterring crime?

What role does education play in preventing criminal behavior in communities?

What strategies can communities use to reduce repeat offenses among criminals?

How do policing tactics impact crime rates and what reforms could help?

Tags

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy