Explain the function of this request : "SELECT Name, ProductNumber, ListPrice AS Price FROM Production.Product ORDER BY Name ASC;" and rewrite the same request with a descendent order.
Explain the function of this request : "SELECT Name, ProductNumber, ListPrice AS Price FROM Production.Product ORDER BY Name ASC;" and rewrite the same request with a descendent order.
before providing an answer - what do you think it means?
I assume it's a grid that lists the products, their prices etc..?
pretty close - your reference to 'grid' and the construction of the table name implies this is not access sql. In access it would be referred to as a view or a query
Appreciated, how about the second half of the question?
Suggest you review this example for ideas/answers.
Good luck.
For bonus marks, tell the exam writer than as a field name, "Name" sucks because it's a reserved word.
Then again, maybe not quite in that terminology...
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
ORDER BY Name ASC
ORDER BY Name DESC
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.