Question: Which of the following will select the SSN field from the PayInfo table and then sort the records in descending order by the SSN field?

Which of the following will select the SSN field from the PayInfo table and then sort the records in descending order by the SSN field?
a. SELECT SSN FROM PayInfo DESC
b. SELECT SSN FROM PayInfo ORDER BY SSN DESC
c. SELECT SSN FROM PayInfo WHERE SSN DESC
d. SELECT SSN FROM PayInfo SORT SSN DESC

Step by Step Solution

★★★★★

3.32 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

b SELECT ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Microsoft Visual Basic Questions!

Which of the following will select the SSN field from the tblPayInfo table and then sort the records in descending order by the SSN field? a. SELECT SSN FROM tblPayInfo DESC b. SELECT SSN FROM...

I am terrible at access and not sure on how to write the formulas. I have done what is in yellow. Can someone help this is due Friday at 10am Central Time. Attached is the rubric and all of the...

I don't have any more information. Whatever information I have can you help me with this? all I know it's about Microsoft access. Kindly help me with this problem. 1. In the Member table, find the...

6. Export the tbiMember table as an XML file named HamiltonMember to the AddCases folder; do not create a separate XSD file. Save the export steps. 7. Create and save a query named qryDistantMembers...

1. SQL stands for Structured Quick Language Select Query Language a. b. c. Semi-Quick Language d. Structured Query Language 2. Which of the following will select the State and Sales fields from the...

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

The following captures are the 4 tables that were already done in the access file which will be used to answer the questions on the Word document. Questions: Could you please help me complete this...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

In 2000 the GSS asked whether a subject is willing to accept cuts in the standard of living to help the environment (GRNSOL), with categories (vw = very willing, fw = fairly willing, nwu = neither...

Tracy Company, a manufacturer of air conditioners, sold 100 units to Thomas Company on November 17, 2011. The units have a list price of $500 each, but Thomas was given a 30% trade discount. The...

On the left are a series of Control Activities commonly used in Accounting. On the right, identify the control activity as either preventative or detective. Prompt 1 Segregating duties between the...

A manufacturing plant has an electrical load of 5000 kW at 0.80 power factor, lagging. It has been decided to replace a 500 HP induction motor that drives a pump. This motor operates at an efficiency...

Section 1.10 cites as a pitfall the utilization of a subset of the performance equation as a performance metric. To illustrate this, consider the following two processors. P1 has a clock rate of 4...

The results of the SPEC CPU 2006 bzip2 benchmark running on an AMD Barcelona has an instruction count of 2.389E12, an execution time of 750 s, and a reference time of 9650 s. 1. Find the CPI if the...

Assume a 15 cm diameter wafer has a cost of 12, contains 84 dies, and has 0.020 defects/cm 2 . Assume a 20 cm diameter wafer has a cost of 15, contains 100 dies, and has 0.031 defects/cm 2 . 1. Find...

A person wants to invest $10,000 into stocks: a high tech company (T) with an expected annual return of 12% and a risk index of 8; and a regulated power company (P) with an expected annual return of...

Posting from the journal to the ledger does NOT involve which of the following steps? a.Enter the amount of each transaction in the accounts. b.Enter the page of the journal from which each...

Required information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets...