查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。语句如下:SELECT BookName, AuthorFROM BookWHERE Len(Author)_________
举一反三
- 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
- 查询图书名称含有“程序”的图书信息。语句如下:SELECT BookCode, BookName, Author, Price, DiscountFROM BookWHERE BookName LIKE ________
- 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,...WHERELenth(Author)=8
- 在查询语句SELECT bookname as name,author,pric...ks中,名称peichang指的是( )