Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29675 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / aravind
where is used when no group by functions are used whereas
having is used when group functions are used
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
What is the difference between join and inner join?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What different steps will a sql server developer take to secure sql server?
Can we create clustered index on composite key?
What do you understand by triggers and mention the different types of it?
What is inner join? Explain with an example?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is primary key and example?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Which tcp/ip port does the sql server run on? How can it be changed?
State a few properties of relational databases?
How to enter binary string literals in ms sql server?
