WE can use group by clause in where clause. For Ex: SELECT column

which clause we are not used in where clause?

Question Posted / manikanta

3 Answers
7530 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

Please Help Members By Posting Answers For Below Questions

How to write text literals in oracle?

1019

What are the set operators union, union all, minus & intersect meant to do?

936

How to use "for" statements in oracle?

1017

How to open and close an explicit cursor in oracle?

996

How to compare dates in oracle sql?

1041

How do you store pictures in a database?

949

Explain about achiever in sql?

979

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1978

What is catalog in Oracle?

1264

How to assign query results to variables?

1011

What is a lookup table in oracle?

929

How to put more than 1000 values into an oracle in clause?

971

What is the use of oracle?

981

How to create a new oracle data file?

969

Explain the use of indexes option in imp command.

1085