select dummy,count(1) from dual group by dummy; O/p:
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The o/p of the below query.. select 0/1 from dual group by dummy;
- select min(dummy) from dual union all select max(dummy) from dual group by dummy; o/p: ??
- select dummy from dual minus select * from dual what would be output ?
- select max(5)*min(5)/avg(5) from dual group by dummy; o/p:
- select min(dummy) from dual order by dummy union all select max(dummy) from dual; O/p:
- select rownum from dual;
- select dummy from dual ?
- select * from dual ?