select min(dummy) from dual order by dummy union all select max(dummy) from dual; O/p:

Keep practicing — related questions

• 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 dummy,count(1) from dual group by dummy; O/p:
• What will be the output of- "Select 1 from dual UNION Select 'A' from dual"
• What is the result of the following SQL: Select 1 from dual UNION Select 'A' from dual;
• select dummy from dual ?
• select * from dual ?