Interested to Buy Any Domain ? << Click Here >> for more details...
which clause we are not used in where clause?
- 3 Answers
- 7635 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 use an oracle sequence generator in a mapping?
What are the advantages of oracle?
Explain the use of analyse option in exp command.
What is a private synonym?
How to convert a string to a date in oracle database?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Is oracle a programming language?
What are the uses of a database trigger?
What is recovery manager(rman) backup in Oracle?
How can we find out the duplicate values in an oracle table?
Can multiple cursors being opened at the same time?
How to use "for" statements in oracle?
List out the difference between commit, rollback, and savepoint?
11. Display the client number and name and the client number and name of the person who referred that client.
What is an oracle wallet?
