Which of the following SELECT statements will select the ItemNum and ItemDesc fields from the tblItems table?
A)SELECT ItemNum OR ItemDesc FROM tblItems
B)SELECT ItemNum AND ItemDesc FROM tblItems
C)SELECT ItemNum, ItemDesc IN tblItems
D)SELECT ItemNum, ItemDesc FROM tblItems

Question

Quizplus · Accepted Answer

The correct syntax for selecting multiple columns in SQL is to list them separated by commas after the SELECT keyword. Option D correctly lists the ItemNum and ItemDesc columns using this syntax. Option A and Option B use incorrect syntax for selecting multiple columns, and Option C uses an incorrect keyword IN.

Which of the Following SELECT Statements Will Select the ItemNum