MODIFY PROJECT e:\vfp?ì°?\xsgl\xsgl.pjx select * from course where cname like "*p" select * from course where not exists (select * from grade) select * from course where not exists (select * from grade where cno=course.cno) select * from course where cno not in (select cno from grade ) select * from course where ccredit=4; union; select * from course where ccredit=4 select * from course where ccredit=4; union; select * from course where ccredit=3 select * top 2 from course where ccredit=4 select * top 2 from course where ccredit=4 order by ccredit select * top 1 from course where ccredit=4 order by ccredit select * top 1 from course where ccredit=4 order by ccredit desc select * top 1 from course where ccredit=4 order by ccredit asc select * top 1 from course order by ccredit asc select * top 2 from course order by ccredit select * top 2 from course order by ccredit desc select * top 2 from course order by ccredit desc into array tmp ?tmp select * top 2 from course order by ccredit desc into table ccredit2 insert into course values("333","C++BUilder",2) list create table grade3(sno c(5),cno c(10),grade n(6)) use grade 3 use grade3 list appe list BROWSE LAST