1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we use where and having clause together?

Question Posted / harika


Can we use where and having clause together?..

Answer / Shadab Ali

Yes, it is possible to use both WHERE and HAVING clauses in a SQL query. The WHERE clause filters rows before grouping, while the HAVING clause filters groups after grouping.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How data can be copied from one table to another table?

1 Answers  

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

How do you delete duplicate records in sql server?

1 Answers  

Can we use max in where clause?

1 Answers  

whats the maximum size of view state??

1 Answers  

mention different types of relationships in the dbms?

1 Answers  

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

what are candidate key, alternate key and composite key? : Sql server database administration

1 Answers  

How many triggers are possible per table?

1 Answers  

Explain about extended stored procedure?

1 Answers  

How to recreate an existing index in ms sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories