what is difference between having and where clause ?

Answer Posted / anil sharma

Having clause ia used only with group by, and where used with any input type

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to sort the query output with order by clauses in ms sql server?

815


Define magic tables in sql server?

756


What are the types of dml?

733


What happens if null values are involved in string operations?

715


what are triggers? : Sql server database administration

657






How to test a dml trigger in ms sql server?

756


Write a program to fetch first 10 records from a file?

759


tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

749


What are dml triggers and types of dml triggers?

714


What is the difference in accessing db between sql server vs sql azure?

166


Explain the difference between functions and stored procedures in sql server?

674


How to defragment table indexes?

699


What is the New in SQL server 2008?

732


What is difference between line feed ( ) and carriage return ( )?

679


What is difference between clustered and non clustered index?

702