Multiple choice technology databases

select min(dummy) from dual union all select max(dummy) from dual group by dummy; o/p: ??

  1. Two rows of value X and X

  2. Error: SQL command not properly ended

  3. Error: Not a proper GROUP BY clause

  4. X

  5. NULL

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MIN(DUMMY) returns 'X' and MAX(DUMMY) returns 'X'. UNION ALL combines both results, producing two rows. DUAL has only one row with DUMMY='X'.