what is difference between having and where clause ?
Answer Posted / anil sharma
Having clause ia used only with group by, and where used with any input type
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is set nocount on and what is set nocount off?
What is dbcc updateusage?
What is the difference between drop table and truncate table?
What are the different types of stored procedures?
What is the use of sign function?
What to perform pattern match with the like operator?
How to write a query with a left outer join in ms sql server?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What are policy management terms?
What is the standby server?
What is the difference between nvl and nvl2?
How to execute a sql statement using odbc_exec()?
Why I am getting this error when dropping a database in ms sql server?
How to list all field names in the result set using mssql_field_name()?
What are page splits?