数据库中有两个用户scott和myuser,物资表wz是属于myuser用户的,但当前用户是scott,要求查询物资表wz(wno,wname,wtype,wunit)物资单位wunit列为null的记录,取结果的前5条记录显示,以下正确的SQL语句是()
- A、select*from scott.wz where wunit is null and rownum<5
- B、select*from myuser.wz where wunit = null and rownum<5
- C、select*from myuser.wz where wunit is null and rownum<6
- D、select*form scott.wz where wunit is null and rownum<6
正确答案:C
答案解析:有
微信扫一扫手机做题