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
Explain features and concepts of analysis services?
How do I create a stored procedure in sql server?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How to delete an existing database user?
How to sort the query output with order by clauses in ms sql server?
What is abstracting periodical?
What are binary string data types in ms sql server?
Explain use of expression builder.
Is ssrs support other database except ms sql server?
What is pessimistic concurrency?
how would you improve etl (extract, transform, load) throughput?
When you use @@error and try-catch?
how to do partition in sqlserver
What happens when converting big values to numeric data types?
What is data source view or dsv? : sql server analysis services, ssas