🎴 Flashcard Mode

Oracle Database and SQL Query Quiz

Card1 / 16
Mastered0
Review0
QuestionClick to flip

select dummy,count(1) from dual group by dummy; O/p:

AnswerClick to flip back
A
X,1
💡 Explanation:

DUAL contains exactly one row where DUMMY='X'. COUNT(1) counts the number of rows, which is 1. The GROUP BY clause is properly formed.

Change Mode