4. 使用连接查询“楚浩然”借阅图书的书号、书名、借阅日期、归还日期,结果按照借阅日期的降序排列。 语句及结果:
时间: 2024-03-19 19:45:01 浏览: 94
SQL语句如下:
```
SELECT Borrow.Bno, Bname, Bdate, Rdate
FROM Borrow
INNER JOIN book ON Borrow.Bno = book.Bno
INNER JOIN reader ON Borrow.Rno = reader.Rno
WHERE Rname = '楚浩然'
ORDER BY Bdate DESC;
```
假设查询结果如下:
| Bno | Bname | Bdate | Rdate |
|--------------------|---------------|-------------|-------------|
| 978-7-5682-5042-9 | 精密制造工学基础 | 2023-04-13 | 2023-05-26 |
| 978-7-5682-6142-5 | 机械制图 | 2023-03-16 | 2023-04-15 |
阅读全文
相关推荐
![-](https://img-home.csdnimg.cn/images/20241231044833.png)
![-](https://img-home.csdnimg.cn/images/20241231044930.png)
![-](https://img-home.csdnimg.cn/images/20241231044930.png)
![doc](https://img-home.csdnimg.cn/images/20241231044833.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)
![ppt](https://img-home.csdnimg.cn/images/20241231044937.png)
![doc](https://img-home.csdnimg.cn/images/20241231044833.png)
![ppt](https://img-home.csdnimg.cn/images/20241231044937.png)
![.rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)