which clause we are not used in where clause?
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 rename an index?
State the various uses of dbcc command?
How many anonymous blocks can be defined?
Explain the use of record option in exp command.
How to unlock the sample user account in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to assign query results to variables?
How to assign values to data fields in record variables?
What is the recommended interval at which to run statspack snapshots, and why?
How to retrieve values from data fields in record variables?
What is meant by joins? List out the types of joins.
Explain parameter file in oracle.
How to omit columns with default values in insert statement in oracle?
What is the fastest query method to fetch data from the table?