Question

What commands would you type and execute to return only the ProductSubcategoryID, ProductCategoryID, Name, and ModifiedDate columns?

Answer 1

SELECT ProductSubcategoryID,ProductCategoryID,Name,ModifiedDate

FROM table_name;

Step-by-step explanation:

The above-written command is in SQL(Structured Query Language). This language is not case-sensitive so you can also write the SQL keywords in lowercase like select, from.

Select is used to print the columns that you will specify separated by commas and from tells from which table the columns are to be selected.