What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
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
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How to convert a unicode strings to non-unicode strings?
Explain what you mean by 3 tier architecture.
What stored by the model?
What type of locking occurs during the snapshot generation? : sql server replication
Tell me what are the advantages of using stored procedures?
Why it is recommended to avoid referencing a floating point column in the where clause?
What is acid mean in sql server?
Explain what is lock escalation?
how to avoid cursors? : Sql server database administration
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is the cpu pressure?
What do you understand by a stored procedure?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
what is difference between view and Dip.