Question

Select statement can be used to display specific columns of the table by specifying the column names, separated by ______________.

• A. Underscore (-)
• B. Space
• C. Tab
• D. Commas (,)

Answer 1

The correct option is D Commas (,)

Select statement can be used to display specific columns of the table by specifying the column names, separated by commas.

SELECTis the SQL command used to retrieve records. This command syntax can be totally simplistic or very complicated.

The SQL SELECT statement returns a result set of records from one or more tables. A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data query language command.