Select Top 15 SealData.Code as 印章编号..... From ((((((SealData Left Join Company On SealData.SNO=Company.SNO) Left Join Shape On SealData.SdShape=Shape.Type) Left Join Material On SealData.BZ1=Material.BZ1) Left Join Model On SealData.ModelNo=Model.ModelNo) Left Join SealStatus On SealData.SSCode=SealStatus.SSCode) Left Join AuditingUnit On SealData.AuCode=AuditingUnit.AuCode) Where ... Order By SealData.CodeWhere及一个列我就不写出来了,我是在VB中连ORACLE的,这条语句在MSSQL下运行正确,但在连接ORACLE时,提示未找到预期的FROM什么的。如果我将Top 15这个去掉,就一切正常,问题应该在Top 这个语句上,请问,这条SQL语句该如何改,才能在ORACLE下运行呢?谢谢。
解决方案 »
- 表空间删除 数据库无法打开
- 怎么样求上一个月同星期几的平均值啊
- 请教SQL
- 就一张表,两个字段,求一句SQL,在线等
- toad 和 plsqldev 的比较
- 消除重复问题,急!!!!!!!!!!!!!!!
- 求一个返回树结构排序的存储过程。
- 向Oracle数据库导入数据时,提示 'IMP-00020:用于列缓冲区大小(22)的长整数列过大'如何解决?(在线等)
- 怎么把一个大的字符串存到数据库的一个字段里
- 关于Oracle下用相同的字母组合在区分大小写的前提下定义表字段的提问
- log报"已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入",但什么数据都没导入(dmp文件正常)
- oracle实现sqlserver isdate函数方法
FROM (SELECT sealdata.code AS Ó¡Õ±àºÅ,.. .
FROM sealdata
LEFT JOIN company ON sealdata.sno = company.sno
LEFT JOIN shape ON sealdata.sdshape = shape.TYPE
LEFT JOIN material ON sealdata.bz1 = material.bz1
LEFT JOIN model ON sealdata.modelno = model.modelno
LEFT JOIN sealstatus ON sealdata.sscode = sealstatus.sscode
LEFT JOIN auditingunit ON sealdata.aucode = auditingunit.aucode
WHERE .. .
ORDER BY sealdata.code)
WHERE rownum <= 15
FROM (SELECT sealdata.code AS 印章编号,.. .
FROM sealdata
LEFT JOIN company ON sealdata.sno = company.sno
LEFT JOIN shape ON sealdata.sdshape = shape.TYPE
LEFT JOIN material ON sealdata.bz1 = material.bz1
LEFT JOIN model ON sealdata.modelno = model.modelno
LEFT JOIN sealstatus ON sealdata.sscode = sealstatus.sscode
LEFT JOIN auditingunit ON sealdata.aucode = auditingunit.aucode
WHERE .. .
ORDER BY sealdata.code)
WHERE rownum <= 15--oralce 没有top这种写法,只能用rownum来代替.