which clause we are not used in where clause?
- 3 Answers
- 6520 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / manikanta
WE can use group by clause in where clause.
For Ex: SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
We can't use case statement in where clause.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to specify default values in insert statement using oracle?
List out the types of joins.
How to drop an existing view in oracle?
What is truncate oracle?
How do I find the database name in oracle?
What do you mean by group by clause?
What is a sub query? What are its various types?
Explain parameter file in oracle.
what happened to the global index when I truncate the data in one of the partition?
Explain the use of file option in exp command.
How to download oracle database 10g xe?
Is rowid unique in oracle?
Can objects of the same schema reside in different tablespace?
What is a trigger and what are its types?
What is the difference between Delete, Truncate and Drop in Oracle?
