上周的sql练习，我全错了。。呵呵
fromtbl_test1
where trunc(created)=to_date('
(case 51Testing软件测试网f*d(f UO)d;B#q
when object_id<10000 then 'a'
xy [n+Z;zq0 when object_id>=10000 and object_id<20000 then 'b'
3Oq9YQ;\#G0o ~0 when object_id>=20000 and object_id<30000 then 'c'
,Ek!u7HA1t2u J;lor0 when object_id>30000 then 'd'51Testing软件测试网;C u+]2x)T o S7u Q D a
end) as标签51Testing软件测试网o8{!Z*h x Tw n!]
from tbl_test1
51Testing软件测试网RP ] u o
DBA
K5w)Lc M0
请dba在我们的答案都发出后给我们正确的多种写法。谢谢
6rZ4Z3e s Tm kO0１．select*fromtbl_test
where((a.object_id = b.object_id)and(c.object_id<>a.object_id))
２．selectobject_name,to_char(created,'yyyy-mm-dd')
fromtbl_test1
whereto_char(created,'yyyy-mm-dd')='
３．selectobject_id,51Testing软件测试网 R4N0C}nJ
(case
j aT/IQ q0 whenobject_id<10000then'a'51Testing软件测试网
_@7Xu'x,a0nYS
whenobject_id>=10000andobject_id<20000then'b'
^ o:x0]%AKF@ A0 whenobject_id>=20000andobject_id<30000then'c'51Testing软件测试网4Z"mi p]2A
whenobject_id>30000then'd'51Testing软件测试网4g.f7x zr
else'e'51Testing软件测试网5q9q)p+fwT`
end)asflag
p:z"H'}
T^(T-F e0 fromtbl_test1
发件人:dba51Testing软件测试网|6c;J6x&m+e5l_
主题:sql练习
应领导的要求,给测试组的各位出了一组sql的练习题.各位练习一下
在开发库的KF用户下有3个表tbl_test1,tbl_test2,tbl_test3是用来做这3个题的.
大家把这些问题的sql写出来.请在明天下班前将各自的答案提交一下.谢谢!
1 tbl_test1和tbl_test2里面都有但是tbl_test3里面没有的数据.
2 请找出tbl_test1表中在
3 给tbl_test1表按照object_id分分等级并打标签:
object_id<10000的属于打a标签
10000<object_id<20000打b标签
20000<object_id<30000打c标签
30000<object_id打d标签
结果显示如下所示:
OWNER OBJECT_NAME OBJECT_ID 标签
------------------------------ -------------------------------------------------------------------------------- ---------- ----
P_YZKF SEQ_Y_OLYMPIC_YN_0806_UG 70497 d
SYS oracle/i18n/data/lx20202.glb 23591 c
PUBLIC V$OBSOLETE_PARAMETER 1101 a
SYSTEM LK_MV_TEST1 63900 d
PUBLIC /a9dac051_ProfileRefErrors 25699 c
P_YZKF TBL_Y_PUTIAN_HJ_0805_USRSND 60220 d
SYS /e8b5ace4_StyleSheetResolvedSt 17902 b
SYS sun/io/CharacterEncoding$2 20344 c
PUBLIC /cbfc
PUBLIC DBMS_MONITOR 8848 a
TAG:
