Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 9858 Views
- I also Faced
- E-Mail Answers
Answer Posted / pawan378
in addition to the above correct answers ..
Having Clause allows to add conditions using functions
Ex: COUNT(*) > 2
at on the same phrase of the query. this will be basically
to avoid sub queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between primary key and clustered index?
How do I completely remove sql server instance?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What are the diifferences between the ms sql server vs mysql?
Explain mixed authentication mode of sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How do you implement session management in SQL Server mode?
How do you create a clustered index?
How to replace null values in expressions using isnull()?
Do you know what is a linked server in sql server?
Can truncate be rolled back?
What are sparse columns?
Can you explain what is the use of custom fields in report?
What are transactions and its controls?
