伊兰特2013款报价:MSSSQL 中 UNION ALL 集合查询的TOP问题

来源:百度文库 编辑:神马品牌网 时间:2024/04/29 04:04:02
我用
SELECT zt_xx.xx_table, qiye.id, qiye.name, qiye.jy, qiye.l_bm, qiye.l_dz,
qiye.l_phone, qiye.l_fax, qiye.l_mail
FROM qiye, zt_xx
WHERE qiye.id = zt_xx.xx_id AND zt_xx.zt_id = 13 AND zt_xx.xx_table = 'qiye'
UNION ALL
SELECT zt_xx.xx_table, xx.id, xx.bt, xx.nrlb, xx.z_yzbm, xx.z_dz, xx.z_phone, xx.z_fax,
xx.z_mail
FROM xx, zt_xx
WHERE xx.id = zt_xx.xx_id AND zt_xx.zt_id = 13 AND zt_xx.xx_table = 'xx'
UNION ALL
SELECT zt_xx.xx_table, zsxm.id, zsxm.name, zsxm.lb, zsxm.l_yb, zsxm.x_dz,
zsxm.l_phone, zsxm.l_fax, zsxm.l_mail
FROM zsxm, zt_xx
WHERE zsxm.id = zt_xx.xx_id AND zt_xx.zt_id = 13 AND zt_xx.xx_table = 'zsxm'
UNION ALL
SELECT zt_xx.xx_table, tz.id, tz.name, tz.lb, tz.l_web, tz.l_dz, tz.l_phone, tz.l_fax,
tz.l_mail
FROM tz, zt_xx
WHERE tz.id = zt_xx.xx_id AND zt_xx.zt_id = 13 AND zt_xx.xx_table = 'tz'
ORDER BY name
查处数据但是只希望取集合中前5条记录应该怎么写啊

可以使用top5进行筛选的