Writing SELECT StatementsThe tblBicycle table contains five fields: ItemNum, ItemName, Color, Price, and Quantity. The Price and Quantity fields are numeric; all other fields are text. The dataset name is BicycleDataSet.
Write a SELECT statement to select all red bicycles. Order the bicycles in descending order by quantity.
What will be an ideal response?
SELECT ItemNum,ItemName,Color,Price,QuantityFROM tblBicycleWHERE Color = 'Red'ORDER BY Quantity DESC
Computer Science & Information Technology
You might also like to view...
Text boxes, when added, are restricted to the confines of a text placeholder.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
The ____ tool creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source.
A. Form B. Database C. Query D. Workbook
Computer Science & Information Technology