please solve this question
tomorrow is my exam and I am confused
Answers
a. Select * from Store order by LastBuy;
b. Select ItemNo, Item from Store where Rate > 15;
c. Select * from Store where SCode = 22 or Qty > 110;
- Select is used to retrieve/display information from the table.
- Where is a clause used to define conditions.
- Or is a logical operator that checks for one or more conditions and results to True only if either of the conditions are True.
- Order by is a clause used to specify in which order the data needs to be arranged.
In query (a), we're representing all the data using an asterisk (*). When you want to retrieve all the data from the table, you use an asterisk. We use order by since the question asks to arrange the data according to a specific column.
In query (b), rather than using an asterisk, we're specifying which columns are to be displayed by typing out the column names. We use where so that we can specify the condition.
In query (c), we're specifying two conditions using the logical operator, or. If either of the conditions satisfies the data, it will be displayed.
Answer:
a. Select * from Store order by LastBuy;
b. Select ItemNo, Item from Store where Rate > 15;
c. Select * from Store where SCode = 22 or Qty > 110;
- Select is used to retrieve/display information from the table.
- Where is a clause used to define conditions.
- Or is a logical operator that checks for one or more conditions and results to True only if either of the conditions are True.
- Order by is a clause used to specify in which order the data needs to be arranged.
In query (a), we're representing all the data using an asterisk (*). When you want to retrieve all the data from the table, you use an asterisk. We use order by since the question asks to arrange the data according to a specific column.
In query (b), rather than using an asterisk, we're specifying which columns are to be displayed by typing out the column names. We use where so that we can specify the condition.
In query (c), we're specifying two conditions using the logical operator, or. If either of the conditions satisfies the data, it will be displayed.