2013年9月11日

Databases Questions & Answers

摘要： Databases Questions & Answers1.What are two methods of retrieving SQL?　2.What cursor type do you use to retrieve multiple recordsets?3.What action do you have to perform before retrieving data from the next result set of a stored procedure?Move the cursor down one row from its current position. 阅读全文

posted @ 2013-09-11 00:20 samules 阅读(214) 评论(0) 推荐(0) 编辑

SQL语句

摘要： Student(S#,Sname,Sage,Ssex) 学生表S#：学号；Sname：学生姓名；Sage：学生年龄；Ssex：学生性别Course(C#,Cname,T#) 课程表C#,课程编号；Cname：课程名字；T#：教师编号SC(S#,C#,score) 成绩表S#：学号；C#,课程编号；score：成绩Teacher(T#,Tname) 教师表T#：教师编号； Tname：教师名字问题：1、查询“001”课程比“002”课程成绩高的所有学生的学号；select a.S# from (select s#,score from SC where C#='001') a,( 阅读全文

posted @ 2013-09-11 00:10 samules 阅读(160) 评论(0) 推荐(0) 编辑

导航