没有合适的资源?快使用搜索试试~ 我知道了~
数据库语句.txt
需积分: 10 0 下载量 136 浏览量
2019-08-12
16:22:46
上传
评论
收藏 2KB TXT 举报
温馨提示
试读
2页
sdcdsvcejf9vreuvds vpodsvsd哦iVS觉得v但是viv的iiv的数据库偶都vi接送i的v哦的水平java webpdf
资源推荐
资源详情
资源评论
1.select count(1) from xs
2.select *from(select xh,'2018'-substr(sfzh,7,4) nl from xs)h,xs where xs.xh=h.xh
3.select*from js,js_kc,kc where js.jsh=js_kc.js_jsh and kc.kch=js_kc.kc_kch and xs=1
4.select xh,xm,sfzh from xs
5.select*from xy,(select distinct xy_bh from js)h where xy.bh=h.xy_bh
6.select*from xs_kc where cj<'80' and cj>'60'
7.select*from xs_kc where cj='80' or cj='60' or cj='70'
8.select*from xs where bj=? and xb='Å®'
9.select *from xs order by xh desc
10.select*from xs order by xh desc,sfzh asc
11.select count(1) from xs where bj =?
12.select xs_xh,kc_kch from (select rownum rn,xs_xh,cj,kc_kch from (select xs_xh,cj,kc_kch from xs_kc order by cj desc)) where rn=1
13.select avg(cj) from xs,xs_kc where xs.xh=xs_kc.kc_kch and bj=?
14.select avg(cj) from xs_kc,(select kc_kch,count(1) from xs_kc group by kc_kch having count(1)>=5)a
where xs_kc.kc_kch=a.kc_kch and a.kc_kch like '3%'
15.select a.xs_xh from
(select xs_xh,max(t)k from (select xs_xh,max(cj)t from xs_kc group by xs_xh) group by xs_xh)a,
(select xs_xh,min(s)l from (select xs_xh,min(cj)s from xs_kc group by xs_xh) group by xs_xh)b
where a.xs_xh=b.xs_xh
and a.k<'90'and b.l>'70'
16.select avg(cj) from xs_kc,xs where xs.xh=xs_kc.xs_xh and bj=? and kc_kch=?
17.select *from xs_kc where
18.select kcmc,kc_kch,cj from xs_kc,xs,kc where kc.kch=xs_kc.kc_kch and xs.xh=xs_kc.xs_xh and substr(sfzh,7,4)>='1998'
19.select c.xh,xm,d from
(select xh,substr(sfzh,7,6)b from xs where xh=180100160)a,
(select xh,substr(sfzh,7,6)d from xs)c,xs
where
xs.xh=c.xh and a.b=c.d
20.select cj from xs_kc,js_kc where js_kc.kc_kch=xs_kc.kc_kch and js_jsh=? kc_kch=?
21.
2.select *from(select xh,'2018'-substr(sfzh,7,4) nl from xs)h,xs where xs.xh=h.xh
3.select*from js,js_kc,kc where js.jsh=js_kc.js_jsh and kc.kch=js_kc.kc_kch and xs=1
4.select xh,xm,sfzh from xs
5.select*from xy,(select distinct xy_bh from js)h where xy.bh=h.xy_bh
6.select*from xs_kc where cj<'80' and cj>'60'
7.select*from xs_kc where cj='80' or cj='60' or cj='70'
8.select*from xs where bj=? and xb='Å®'
9.select *from xs order by xh desc
10.select*from xs order by xh desc,sfzh asc
11.select count(1) from xs where bj =?
12.select xs_xh,kc_kch from (select rownum rn,xs_xh,cj,kc_kch from (select xs_xh,cj,kc_kch from xs_kc order by cj desc)) where rn=1
13.select avg(cj) from xs,xs_kc where xs.xh=xs_kc.kc_kch and bj=?
14.select avg(cj) from xs_kc,(select kc_kch,count(1) from xs_kc group by kc_kch having count(1)>=5)a
where xs_kc.kc_kch=a.kc_kch and a.kc_kch like '3%'
15.select a.xs_xh from
(select xs_xh,max(t)k from (select xs_xh,max(cj)t from xs_kc group by xs_xh) group by xs_xh)a,
(select xs_xh,min(s)l from (select xs_xh,min(cj)s from xs_kc group by xs_xh) group by xs_xh)b
where a.xs_xh=b.xs_xh
and a.k<'90'and b.l>'70'
16.select avg(cj) from xs_kc,xs where xs.xh=xs_kc.xs_xh and bj=? and kc_kch=?
17.select *from xs_kc where
18.select kcmc,kc_kch,cj from xs_kc,xs,kc where kc.kch=xs_kc.kc_kch and xs.xh=xs_kc.xs_xh and substr(sfzh,7,4)>='1998'
19.select c.xh,xm,d from
(select xh,substr(sfzh,7,6)b from xs where xh=180100160)a,
(select xh,substr(sfzh,7,6)d from xs)c,xs
where
xs.xh=c.xh and a.b=c.d
20.select cj from xs_kc,js_kc where js_kc.kc_kch=xs_kc.kc_kch and js_jsh=? kc_kch=?
21.
资源评论
weixin_44189891
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功