What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26981 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / swati mandve
where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to insert multiple rows with one insert statement in ms sql server?
Tell me what is the difference between locking and multi-versioning?
How to set database to be single_user in ms sql server?
Why main is user defined function?
What is rolap and its advantage? : sql server analysis services, ssas
How to get the number of affected rows?
Does sql server 2000 clustering support load balancing?
Define model database?
What is a non-clustered index?
What is correlated subquery in sql server?
What is a covered index?
Explain the difference between HTTP and HTTPS in database?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Do you know what is similarity and difference between truncate and delete in sql?
