Interested to Buy Any Domain ? << Click Here >> for more details...
which clause we are not used in where clause?
- 3 Answers
- 7709 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
Explain the use of owner option in exp command.
What is dual table oracle?
Which is better Oracle or MS SQL? Why?
Differentiate between post-database commit and post-form commit?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
interview questions with answer for cts
Explain the use of rows option in exp command.
definition of cluster and non-clustered index?
Explain about functional dependency and its relation with table design?
What is oracle and what are its different editions?
How to create an oracle database manually?
What are the different types of modules in oracle forms?
Is there a combination of "like" and "in" in sql?
What is Java Pool in Oracle?
please explain.. DB architecture ...
