-
HAVING vs WHERE Clause
Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.
Read Best Answer
Editorial / Best Answer
ajaysinghnegi- Member Since Mar-2009 | Mar 27th, 2009
1) HAVING clause can only be used to filter out the aggegate functions whereas WHERE clause cannot filter out the aggegate functions.
2) HAVING clause can be used with GROUP BY function where as WHERE clause cannot be used with group by function.gubba123
- Aug 8th, 2010
Example: Write a query to display the Managers who are working for more than one Departments:Select emp_id, count(distinct dept_id) From emp Where...
Tartauris
- Feb 16th, 2010
Having is used for agregate results while where is used for unagregated results.
-
how would you hide a table in sql. ie the table can be only visible to its maker.
not known yet
ankurlibra
- Sep 26th, 2010
We are misunderstanding the question and I assume that Abhishek want to say that "How we can hide a table info from user?".To hide table info or as per question make it invisible to other user. A tabl...
pravelu
- Apr 23rd, 2010
It can be done using role grants. Grant view or debug privileges to only the set of users who can see these tables. The other users who are not granted the privilege cannot view this table. Every single user is a Schema in Oracle.It is by default, that the table cannot be seen by others.
