肌肉注射操作流程

一．实验目的 使学生熟练掌握数据查询中嵌套查询语句的操作方法，并加深对Transact-SQL语言的查询语句的理解 二．实验软件环境 Microsoft SQL Server 2000上的查询分析器 三．实验内容 要求完成以下查询要求： 1）查询哪一年的图书最多。 2）查询每本借书证的借书册数。 3）今年未借过书的借书证 4）哪个系的同学借书最多。 5）今年哪种类别的书借出最多。 四．实验的结果及分析 根据实验内容，利用SQL语句在查询分析器中输入如下代码并可得相应输出结果， /*查询哪一年的图书最多*/ use Labery_3111001381    select book_year from book group by book_year having sum(book_total)>=all(select sum(book_total) from book group by book_year) /*查询每本借书证的借书册数*/ use Labery_3111001381    select cno,count(cno)as count_borrow from borrow group by cno /*今年未借过书的借书证*/ use Labery_3111001381    select * from card where not exists (select * from borrow where cno=card.cno  ) /*哪个系的同学借书最多*/ use Labery_3111001381    select department from card,borrow where card.cno=borrow.cno group by department having count(borrow.cno)>=all(select count(borrow.cno)from card,borrow where card.cno=borrow.cno group by department) /*今年哪种类型的书借出最多*/ use Labery_3111001381    select category from book,borrow where book.bno=borrow.bno group by category having count(borrow.bno)>=all(select count(borrow.bno)from book,borrow where book.bno=borrow.bno group by category) 五．实验心得体会 对数据库有了进一步的了解，同时对SQL语言的语法也有了进一步的掌握。通过实验，使得对老师及书本上的知识更进一步的了解，加深印象。