What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

Answer Posted / sararh

where clause uesd for the fiend out particulater records and
where clause u write after select statement.

Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are acid properties of transaction?

549


How to use linked server?

591


Tell me what are the essential components of sql server service broker?

508


What is log cache in sql server?

515


Explain view in sql server?

619






What is subquery explain with example?

611


What is the default sql server instance name?

558


Find columns used in stored procedure?

522


What is 2nf example?

548


How many types of stored procedures are there in sql server?

556


What are information schema views?

546


What the class forname () does?

538


explain different types of constraints? : Sql server database administration

513


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

545


What are the acid properties?

551