what is the difference between group and having
give an example with query and sample output

Answer Posted / veeresh kethari

Where: 'WHERE' will filter the data before grouping

Having:'HAVING' will filter,after the grouping the data.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List all the types of user-defined functions?

504


What is statement level trigger?

519


How to connect to a sql server using odbc_connect()?

599


Explain Capacity planning to create a database? and how to monitor it?

3728


Do you know the policy based administration feature of sql server 2008?

557






How to use "begin ... End" statement structures in ms sql server?

499


What is the difference between inner join and equi join?

472


How to loop through result set objects using odbc_fetch_row()?

443


How to return the top 5 rows from a select query in ms sql server?

566


What happens if time-only values are provided as date and time literals?

504


Explain the concepts and capabilities of sql server?

521


What are different backups available in sql server?

579


What is a unique index?

507


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1356


Does partitioning ssd reduce performance?

469