992 select author title price usedprice from books

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: "books" table? (Assume that "books" table has 5 fields and more than 10 records) Correct Percent Answered Select Author, title, price, usedprice from books where usedprice<price order by title 71.992% Select Author, title, price, usedprice from books order by title 13.215% Select Author, title, price, usedprice from Books where usedprice<price order by title 7.89% Select * from Books where usedprice<price order by title 6.903% Unanswered 0% Kai Zhao 4/15/12 9:27 PM Comment [7]: The question says that there are more than 10 records. If there is no WHERE statement, the result set would have the same number of records as the table.s Kai Zhao 4/15/12 9:26 PM Comment [8]: Table name is case sensitive. Books <> books Kai Zhao 4/15/12 9:26 PM Comment [9]: This query would have resulted in too many fields... the image above has 4 fields but the table has 5. If you use SELECT *, all 5 would showup....
View Full Document

Ask a homework question - tutors are online