|
|
|
|
|
|
 Re: "Having clause" restrict row & groups or groups only ? [message #254945 is a reply to message #254933] |
Mon, 30 July 2007 02:13  |
mbapoonam
Messages: 5
Registered: May 2006
Location: India
|
Junior Member |
|
|
This is the question in one of the 1z0-007 SQL paper .
And I found many different anwers for this question.
We use where clause to restrict rows.
but using 'Having clause ' in group by function , we can restrict only group or rows.
Having clause is used to restrict rows or groups ?
If it restrict rows then this query gives error like-
select last_name
from employees
having employee_id=100;
so is it true that 'having clause ' can restrict only group and not the rows
[Updated on: Mon, 30 July 2007 03:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
