What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / pallavi tiwari
in where clause the data that fetched in memory is according
to condition but in having the completed data firstly
fetched in memory and then seperated according to condition.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are statistics?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to disable stored procedure sql server?
What are the difference between clustered and a non-clustered index?
How many types of cursor type are there?
How to write a query with a right outer join in ms sql server?
How to convert character strings into numeric values?
What is the use of set nocount on/off statement?
What is a collation in ms sql server?
What is difference between rollback immediate and with no_wait during alter database?
What are partitioned views and distributed partitioned views?
What is multi-statement table-value user-defined function?
Explain the xml support sql server extends?
What are the steps to process a single select statement?
How many types of database relationship in sql server?