适用于中小截面导线。耐张线夹分三大类即:螺栓式耐张线夹,压缩型耐张线夹,楔型线夹。螺旋式耐张线夹型号有:NLD-1,NLD-2,NLD-3,NLD-4.型号含义:N-耐张线夹L螺旋形,D倒装式。95钢绞线需选用NLD-3比较合适。
oracle 写sql对会员的(年龄状况-性别)分布进行统计,以0-17 18-25 26-35 35以上,以性别分组实现以下效果
select ’0-17’ as nld, count(*) as sl,xb from hygl_hyxx where nl《=17 and xb=’男’group by xb,’0-17’union all select ’0-17’ as nld, count(*) as sl,xb from hygl_hyxx where nl《=17 and xb=’女’group by xb,’0-17’union all select ’17-25’ as nld, count(*) as sl,xb from hygl_hyxx where nl》=18 and nl《=25 and xb=’男’group by xb,’17-25’union all select ’17-25’ as nld, count(*) as sl,xb from hygl_hyxx where nl》=18 and nl《=25 and xb=’女’group by xb,’17-25’union all select ’26-35’ as nld, count(*) as sl,xb from hygl_hyxx where nl》=26 and nl《=35 and xb=’男’group by xb,’26-35’union all select ’26-35’ as nld, count(*) as sl,xb from hygl_hyxx where nl》=26 and nl《=35 and xb=’男’group by xb,’26-35’union all select ’35以上’ as nld, count(*) as sl,xb from hygl_hyxx where nl》35 and xb=’男’group by xb,’35以上’union all select ’35以上’ as nld, count(*) as sl,xb from hygl_hyxx where nl》35 and xb=’女’group by xb,’35以上’
耐张线夹nld-3合适多大的线
NLD耐张线夹:是用来将导线或架空地线固定在耐张绝缘子串上,用耐张线夹起锚固作用。适用于中小截面导线。耐张线夹分三大类即:螺栓式耐张线夹,压缩型耐张线夹,楔型线夹。螺旋式耐张线夹型号有:NLD-1, NLD-2, NLD-3, NLD-4. 型号含义:N-耐张线夹L螺旋形,D倒装式。95钢绞线需选用NLD-3比较合适。