SAS中的SQL语句完全教程.pdf
qw****27
亲,该文档总共23页,到这已经超出免费预览范围,如果喜欢就直接下载吧~
相关资料
SAS中的SQL语句完全教程.pdf
sql语句教程.xls
目录SQLINSERTINTO语句PreviousPageNextPageINSERTINTO语句INSERTINTO语句用于向表格中插入新的行。语法INSERTINTO表名称VALUES(值1,值2,....)我们也可以指定所要插入数据的列:INSERTINTOtable_name(列1,列2,...)VALUES(值1,值2,....)插入新的行"Persons"表:LastNameFirstNameAddressCarterThomasChanganStreetSQL语句:INSERTINTOPer
SQL语句教程.pdf
SQL指令SELECTDISTINCTWHEREANDORINBETWEENLIKEORDERBY函数COUNTGROUPBYHAVINGALIAS表格链接外部链接CONCATENATESUBSTRINGTRIM表格处理CREATETABLECONSTRAINTNOTNULLUNIQUECHECK主键外来键CREATEVIEWCREATEINDEXALTERTABLEDROPTABLETRUNCATETABLEINSERTINTOUPDATEDELETEFROM进阶SQLUNIONUNIONALLINTE
SQL语句教程.pdf
SQL语句教程大全.pdf
SQL指令SELECTDISTINCTWHEREANDORINBETWEENLIKEORDERBY函数COUNTGROUPBYHAVINGALIAS表格链接外部链接CONCATENATESUBSTRINGTRIM表格处理CREATETABLECONSTRAINTNOTNULLUNIQUECHECK主键外来键CREATEVIEWCREATEINDEXALTERTABLEDROPTABLETRUNCATETABLEINSERTINTOUPDATEDELETEFROM进阶SQLUNIONUNIONALLINTE