917 kai zhao 41512 918 pm comment 5 when you use a

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: le from books where title = "%SQL%" 12.032% Select title from books where title = "SQL" 19.329% Select title from books where title like "SQL" 5.917% Kai Zhao 4/15/12 9:18 PM Comment [5]: When you use a wildcard query, you should always use the 'like' operator, instead of '=' Unanswered • 0% Question 4: Multiple Choice Average Score 1.68047 points Which of the following is valid SQL query? Correct Percent Answered Select * from books order by year Select title from books where price ordered by price 3.945% Select title from books where year = 1995 order = descending 5.128% Select * from books where year = 1995 order = descending 6.903% Unanswered • 84.024% 0% Kai Zhao 4/15/12 9:19 PM Comment [6]: 'order by' is the correct syntax Question 5: Multiple Choice Average Score 1.43984 points Which query could possibly generate the following results from the...
View Full Document

This document was uploaded on 02/17/2014 for the course CS 105 at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online