sql语句

1、SqlServer 2005数据库

两张表： sys_loginInfo ， doc_relation     将数字字符串类型的字段转换成int类型的再按此字段排序

  select
        distinct top 10(s.loginName),
        cast (d.Backup3 as int) as relationIDAll,
        s.userID,
        s.password,
        s.userName,
        s.loginName,
        s.deptID,
        s.relationID,
        s.QDrelationID
    from
        sys_loginInfo as s,
        doc_relation as d 
    where
        (
            s.relationID = d.relationID
            or s.QDrelationID = d.relationID
        )
        and s.validState <> '0'
    order by
        cast (d.Backup3 as int) asc ,
        s.userName