要提供Books和 BookType的欄位情況

--bookName 書名

--salePrice 銷售價格

--price 進貨價格

--bookNo 記錄編號

1）select * from Books

2) select * from Books

select * from BookType

3) select bookName ,salePrice from Books

4) select bookName , salePrice from Books where bookNo="YBZT0003"

5) selset bookNo as 圖書記錄編號,bookName as 圖書名,price as 進貨價格

from books where salePrice=20

6) selcet bookName as 圖書的書名,salePrice as 圖書的銷售價格

from books where salePrice between 10 and 50

7) select bookName from books where bookNmae like "%中%"

8) select bookName from books where aaa like "%人%"

--aaa 代表出版社欄位

0