> > >

SQL MCQs

What is the equivalent sql statement of following statement? Select sum(column1) a, count(column2) b from TableA where 1=2

Select 0 a, 0 b from TableA

Select sum(1) a, count(2) b from TableA where column1=column2

Select sum(column1) a, count(*) b from TableA

Select sum(*) a, count(*) b from TableA where 1=2

Select sum(column1) a, count(column2) b from TableA where column1=column2

Answer

Correct Answer: Select 0 a, 0 b from TableA

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it