A COUNT Window cannot be done in a SELECT involving MIN or MAX functions.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".
- select max(5)*min(5)/avg(5) from dual group by dummy; o/p:
- All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause
- All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause
- All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause
- All columns in the SELECT list that are not there in the GROUP function, should be in the group by clause
- What is the output of the below queries: if table A is having 16 rows: select count(*) from A where 10=10; ...
- WHERE keyword could not be used with aggregate functions.