COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How would we script a SQL query to select “Description” from the Item table?
|
SELECT Item.Description
|
|
EXTRACT Description FROM Item
|
|
SELECT Item FROM Description
|
|
SELECT Description FROM Item
|
Explanation:
Detailed explanation-1: -The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2=’value’; In the above SQL statement: The SELECT clause specifies one or more columns to be retrieved; to specify multiple columns, use a comma and a space between column names.
Detailed explanation-2: -In SQL, to retrieve data stored in our tables, we use the SELECT statement.
There is 1 question to complete.