| sunil |
Posted: Nov 09, 2006 09:53:36 AM |
Total Post: 19
Joined: Nov, 2006
|
hi this is sunil
there is a question in test king regarding differnce b/w having n where
if any one knows th ans pls xplain me
regards,
sunil |
|
|
 Vigyan |
| Posted: Nov 09, 2006 01:31:24 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Can you post the question to understand it better?
- Vigyan
|
|
|
|
|
| sunil |
| Posted: Nov 09, 2006 11:08:28 PM | |
|
Total Post: 19
Joined: Nov, 2006
|
Which two statements are true about WHERE and HAVING clauses? (Choose two)
A)A WHERE clause can be used to restrict both rows and groups.
B)A WHERE clause can be used to restrict rows only.
C)A HAVING clause can be used to restrict both rows and groups.
D)A HAVING clause can be used to restrict groups only.
E)A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
F)A HAVING clause CANNOT be used in subqueries.
ANSWER: B,C ...
wt do u think pls explain it
regards,
sunil kumar
|
|
|
|
|
| Jayanta |
| Posted: Nov 11, 2006 04:00:46 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
hi!
answers are b&d.
the reason:
where clause is used to filter out rows before they are grouped by a group by clause, where as groups are filtered out by having clause.
not only, a having clause can also be used in subqueries.
hope this will help.
bye
|
|
|
|
|
| Prakash |
| Posted: Nov 29, 2006 12:31:48 AM | |
|
Total Post: 112
Joined: Aug, 2006
|
I think having can be used to restrict the rows also, After selecting the groups we can restrict tohse rows....isn't it..
|
|
|
|
|
| Jayanta |
| Posted: Dec 18, 2006 05:43:24 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
after selecting the groups there r groups data no rows. so having can only be used to filter out groups data .
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
