Interested to Buy Any Domain ? << Click Here >> for more details...
which clause we are not used in where clause?
- 3 Answers
- 7689 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / chandana
Select avg(sal) from Emp
where avg(sal) >1000;
This gives an error. So, Group Functions(Aggregate) should
not be used in the Where Clause
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is data type in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to initialize variables with default values?
Explain parameter file in oracle.
What is instant client oracle?
How do we create privileges in oracle?
6. Display the client name and order date for all orders using the traditional method.
What is a initialization parameter file in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What is the fastest query method to fetch data from the table?
What is different types of joins?
How to display employee records who gets more salary than the average salary in the department?
Is java required for oracle client?
What do you know about normalization? Explain in detail?
