BookStore数据库中有图书表Book(BookCode,BookName,...WHERELenth(Author)=8
举一反三
- BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询图书名称（BookName）含有“程序”的图书信息。SQL语句: SELECT BookCode,BookName,Author,Price,Discount FROM Book WHERE Name=“%程序%”
- BookStore数据库中有图书表Book(BookCode,BookName,...As最高价与最低价的差值FromBook
- BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句: SELECT BookName, Author FROM Book WHERE Lenth(Author)= 8
- BookStore数据库中有图书表Book(BookCode, BookName..._ BookSort FROM Book
- BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime，BookSort,ISBN,BookPicture,ContentInro,Price,Discount)，其中PublishTime是datetime类型。 A: DISTINCT B: ONLY C: ONE D: PERCENT