sqlÓï¾ä»ù±¾²Ù×÷
1.½¨±íÓï¾ä£ºcreate table
Ó÷¨: create table ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£)
¾ÙÀý£ºÀýÈç´´½¨Ò»¸öѧÉú³É¼¨±í£¬°üº¬µÄ×Ö¶ÎÓУ¬Ñ§Éúid£¬ÐÕÃû£¬ÐԱ𣬰༶£¬³É¼¨create table score(
create table score(
sid nvarchar(10) primary key,
sname nvarchar(10) not null,
sex nvarchar(2),
sclass nvarchar(5),
score int,
check(sex in('ÄÐ','Å®'))
);
2.²åÈëÓï¾ä£ºinsert into
Ó÷¨:insert into ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£) values (Öµ1£¬Öµ2£¬¡£¡£¡£¡£)
Èç¹û×Ö¶ÎÊDZíÖÐËùÓÐ×Ö¶Î×Ö¶ÎÁбí¿ÉÊ¡È¥£¬Ö±½Óд±íÃû¾ÍÐÐÁË
¾ÙÀý:Íù±íscoreÖвåÈë7ÌõÊý¾Ý
insert into score values('95002','СÀî','ÄÐ','01',82)
insert into score values('95003','СÀö','Å®','01',83)
insert into score values('95004','СÕÔ','ÄÐ','01',67)
insert into score values('95005','СÃÀ','Å®','01',78)
insert into score values('95006','СÌï','ÄÐ','01',88)
insert into score values('95007','СÐì','Å®','01',85)
insert into score values('95008','СÍõ','ÄÐ','01',86)
3.²éѯÓï¾ä£ºselect
Ó÷¨£ºselect ×ֶΠfrom ±íÃû where Ìõ¼þ
×ֶμäÓÃ','·Ö¿ª£¬Í¬ÑùÈç¹ûÑ¡Ôñ±íµÄËùÓÐ×ֶΣ¬¿ÉÓÃͨÅä·û*
¾ÙÀý£ºÊä³öscore±íÖгɼ¨ÔÚ60µ½80µÄͬѧµÄËùÓÐÐÅÏ¢
select * from score where score>=60 and score<=80
Êä³öscore ±íÖгɼ¨Îª85»ò86»ò87µÄѧÉúÐÅÏ¢
select * from score where score=85 or score=86 or score=87
Êä³öscore ±íÖа༶Ϊ95001»òÕßÐÔ±ðΪŮÐÔµÄѧÉúµÄÃû×Ö
select sname from score where sclass='95001' or sec='Å®'
4.ɾ³ýÓï¾ä:delete
Ó÷¨£ºdelete from ±íµÄÃû×Ö where Ìõ¼þ
¾ÙÀý£ºÉ¾³ýscore±íÖзÖÊýµÍÓÚ70·ÖµÄ¼Ç¼
delete from score where score<70
Ïà¹ØÎĵµ£º
ÕªÒª£º±¾ÎĽ«½éÉÜSQL Server 2005 Analysis ServicesÖÐÊý¾ÝÍÚ¾òËã·¨À©Õ¹·½·¨£¬ÔÚƽʱ¿ª·¢ÖÐÎÒÃÇÐèÒª¸ù¾ÝÒªÇóÀ´À©Õ¹SSASµÄÍÚ¾òËã·¨¡£
±êÇ©£ºSQL Server 2005 Êý¾ÝÍÚ¾ò Ëã·¨
SSASΪÎÒÃÇÌṩÁ˾ÅÖÖÊý¾ÝÍÚ¾òËã·¨£¬µ«ÊÇÔÚÓ¦ÓÃÖÐÎÒÃÇÐèÒª¸ù¾Ýʵ¼ÊÎÊÌâÉè¼ÆÊʵ±µÄËã·¨£¬Õâ¸öʱºò¾ÍÐèÒªÀ©Õ¹SSA ......
----start
ÎÊÌ⣺²é¿´DB2 °æ±¾---SELECT * from SYSIBM.SYSVERSIONS
ÎÊÌ⣺²é¿´ÏµÍ³ÖÐÓÐÄÄЩ±íÒÔ¼°ÕâЩ±íµÄ¸ÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.TABLES
ÎÊÌ⣺²é¿´Ä³¸ö±íÓÐÄÄЩÁÐÒÔ¼°ÕâЩÁеĸÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.COLUMNS WHERE TABNAME=<YOUR_TABLE_NAME>
---´ýÐøδÍê
---¸ü¶à²Î¼û£ºDB2 SQL ¾«Ò ......
ÔÚT-sqlµÄд·¨ÉÏÓкܴóµÄ½²¾¿£¬ÏÂÃæÁгö³£¼ûµÄÒªµã£ºÊ×ÏÈ£¬DBMS´¦Àí²éѯ¼Æ»®µÄ¹ý³ÌÊÇÕâÑùµÄ£º
1¡¢²éѯÓï¾äµÄ´Ê·¨¡¢Óï·¨¼ì²é
2¡¢½«Óï¾äÌá½»¸øDBMSµÄ²éѯÓÅ»¯Æ÷
3¡¢ÓÅ»¯Æ÷×ö´úÊýÓÅ»¯ºÍ´æȡ·¾¶µÄÓÅ»¯
4¡¢ÓÉÔ¤±àÒëÄ£¿éÉú³É²éѯ¹æ»®
5¡¢È»ºóÔÚºÏÊʵÄʱ¼äÌá½»¸øϵͳ´¦ÀíÖ´ÐÐ
6¡¢×îºó½«Ö´Ðнá¹û·µ»Ø¸øÓû§¡£
Æä´Î£¬¿´Ò»ÏÂS ......
--ÔÚÈÕ³£Î¬»¤£¬¿ª·¢Öг£Óöµ½Ð´Ò»ÏµÁнṹÀàÐ͵ÄsqlÓï¾ä£¬ºÜ·³ºÜÀÛÆäʵ¿ÉÒÔ
--ÀûÓÃSQL*PLUS»·¾³ÃüÁî Éú³É½Å±¾Îļþ
set heading off --¹Ø±ÕÁеıêÌâ
set feedback off --¹Ø±Õ·´À¡ÐÅÏ¢
  ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“”¿Î³Ì±È“”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
SELECT a.S# from (SELECT s#,score from SC WHERE C#='001') a,
(SELECT s#,score fr ......