17,377
社区成员
发帖
与我相关
我的任务
分享
1>select Name from TableX where Name like 'ÕÅ%' order by Age ASC
2>select X.Name from TableX X left join TableY Y on X.code=Y.code where Y.class='计算机' and score<60
select Name from TableX where Code in(select code from TableY where Class='计算机'and Score<60)
3>select X.Name,Y.Class,Y.Score from TableX X join TableY Y on X.code=Y.code
select X.Name,Y.Class,Y.Score from TableX X, TableY Y where X.code=Y.code
4> select X.Name,Y.Class,Y.Score from TableX X full join TableY Y on X.code=Y.code
5>insert into TableX values(97005,'李五',20)
6>update TableX set Age=21 where Code=(select code from TableX where Name='李五')
7>delete from TableX where Code not in (select Code form TableY)