Interested to Buy Any Domain ? << Click Here >> for more details...
which clause we are not used in where clause?
- 3 Answers
- 7685 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 define an anonymous procedure with variables?
How many types of tables are there in oracle?
What is key preserved table?
What is transport network substrate (tns) in oracle?
What is the difference between hot backup and cold backup in oracle?
What are the extensions used by oracle reports?
How can I create database in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What are the different editions of oracle?
State any two functions of oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What are the oracle differences between nvl and coalesce
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
