Interested to Buy Any Domain ? << Click Here >> for more details...
which clause we are not used in where clause?
- 3 Answers
- 7796 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
What is the relationship among database, tablespace and data file?
What is instant client oracle?
When do you get a .pll extension in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What are the arithmetic operations?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the difference between substr & instr functions?
What is a read only transaction in oracle?
Explain cascading triggers.
Explain oracle’s system global area (sga).
What is the recommended interval at which to run statspack snapshots, and why?
How to use values from other tables in update statements using oracle?
Why do we use coalesce function in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to generate query output in html format?
