Write SQL statements for the following:
a. Retrieve all partNumber and partDescription columns from a Parts table
that has 15 different columns.
b. Retrieve records from a Parts table for partNumbers 1000 through 2000.
Display the partDescription only.
c. Insert a new record into a Customer table. Store the following values in
the columns: LName=Osprey, FName=Teola, CNumber=23456. The
columns are ordered as follows: CNumber, LName, FName.
Sorry the answer is not available at the moment…
If you are able to find the answer, please make sure to post it here. So that your Juniors have smile on their lips and feel happy.
Spread the 'tradition of sharing'.