设有图书表,结构如下:Books(cBookId ,cBookName ,cBookCategory,cAuthorName ,iPages,iPrice) 下列查询语句中,能够按书名的字母升序顺序显示书名及其价格的是 ·SELECT * FROM Books ORDER BY cBookName ASC ·SELECT cBookName, iPrice FROM Books ORDER BY cBookName ASC ·SELECT * FROM Books ORDER BY cBookName DESC ·SELECT cBookName, iPrice FROM Books ORDER BY cBookName DESC
答案是:
单选题 ·SELECT cBookName, iPrice FROM Books ORDER BY cBookName ASC
