Question: The tblMagazine table contains three fields. The Cost field is numeric. The Code and MagName fields contain text. a. Write a SQL SELECT statement that
The tblMagazine table contains three fields. The Cost field is numeric. The Code and MagName fields contain text.
a. Write a SQL SELECT statement that arranges the records in descending order by the Cost field.
b. Write a SQL SELECT statement that selects only the MagName and Cost fields from records having a code of PG10.
c. Write a SQL SELECT statement that selects only the MagName and Cost fields from records having a cost of $3 or more.
d. Write a SQL SELECT statement that selects the Visual Basic record.
e. Write a SQL SELECT statement that selects only the MagName field from records whose magazine name begins with the letter C.
f. Open the VB2015\Chap14\Magazine Solution\Magazine Solution (Magazine Solution.sln) file. The application is connected to the Magazines database. Start the application to view the records contained in the dataset, and then stop the application. Open the DataSet Designer window and then start the TableAdapter Query Configuration Wizard. Open the Query Builder dialog box. Use the dialog box to test your SELECT statements from Steps a through e.
Step by Step Solution
3.34 Rating (160 Votes )
There are 3 Steps involved in it
a SELECT Code Cost MagName FROM tblMagazine ORDER BY Cost DESC b SELECT MagName Cost FROM tblMagazine WHERE Code PG10 c SELECT MagName Cost FROM tblMagazine WHERE Cost 3 d SELECT Code Cost MagName FRO... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help