Which command returns all the columns for records in which the value of Col1 is greater than 10 but has a value less than Col2? A)SELECT * FROM Table1 WHERE Col1 10 B)SELECT ALL FROM Table1 WHEN Col1 10 C)SELECT * FROM Table1 IF Col1 10 BUT Col1 10 NOT Col1

Question

Which command returns all the columns for records in which the value of Col1 is greater than 10 but has a value less than Col2? A)SELECT * FROM Table1 WHERE Col1 10 B)SELECT ALL FROM Table1 WHEN Col1 10 C)SELECT * FROM Table1 IF Col1 > 10 BUT Col1 < Col2 D)SELECT ALL FROM Table1 LIKE Col1 > 10 NOT Col1 < Col2

Quizplus · Accepted Answer

The correct syntax for selecting specific records based on a column's value is to use the WHERE clause. In this particular scenario, we need to select all columns from Table1 where the value of Col1 is greater than 10 and less than the value of Col2. The correct syntax for this is: SELECT * FROM Table1 WHERE Col1 > 10 AND Col1 < Col2. The only option that follows this syntax is option A.

Which Command Returns All the Columns for Records in Which