伊兰特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条记录应该怎么写啊
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进行筛选的
MSSSQL 中 UNION ALL 集合查询的TOP问题
union all查询时的错误
VB中如何使用UNION联合查询,提示union未定义是怎么回事。
VB中如何使用UNION联合查询,提示union未定义是怎么回事
散尽所有积分求:The All Saints’ Day Manifesto for European Monetary Union
union是什么意思?
ALL FORLOVE中问是什么意思?
C++中“' must have class/struct/union type”是什么错误
We are all here.中ALL的用法?谢谢
DOTA ALL STARS中木头怎样得?