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
List all the types of user-defined functions?
What is statement level trigger?
How to connect to a sql server using odbc_connect()?
Explain Capacity planning to create a database? and how to monitor it?
Do you know the policy based administration feature of sql server 2008?
How to use "begin ... End" statement structures in ms sql server?
What is the difference between inner join and equi join?
How to loop through result set objects using odbc_fetch_row()?
How to return the top 5 rows from a select query in ms sql server?
What happens if time-only values are provided as date and time literals?
Explain the concepts and capabilities of sql server?
What are different backups available in sql server?
What is a unique index?
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.
Does partitioning ssd reduce performance?