sqlserver的问题 急急急
我现在有两张表 一张员工表 一张部门表employee:
id departmenrtid name
department:
id sort
我现在查询员工表要通过departmentid 和 name两个字段排序 期中departmentid的排序方法是根据department表中的sort来排序的
急急急希望各路神仙帮帮忙 万分感谢 --------------------编程问答--------------------
--------------------编程问答--------------------
select * from employee,department where employee.departmenrtid=department.id
order by departmenrtid sort asc,employee.id asc
--------------------编程问答-------------------- --------------------编程问答--------------------
select * from employee e join department d
on e.departmenrtid = d.id
order by e.name asc,d.sort asc
--------------------编程问答--------------------
select * from employee e order by (select sort from department where e.departmentid=department.id) asc,name asc
--------------------编程问答-------------------- select e.* from employee e left join department d
select e.* from employee e left join department d
on e.departmenrtid = d.id
order by d.sort asc,e.name asc
on e.departmenrtid = d.id
order by d.sort asc,e.name asc
--------------------编程问答-------------------- 这么多答案,lz不要凌乱了 --------------------编程问答-------------------- --------------------编程问答-------------------- 各位的我都试过了 查出来的结果都稍微有点差 排序的时候 name字段干预到departmentid了 例如:
有三条数据是这样的
employee:
id departmentid name
1 83D36C5D-9C96-4B86-A80B-F66355C03A79 系统管理员
2 8802659F-D5EF-4D8E-BFD0-FFE5C058850F 张武装
3 83D36C5D-9C96-4B86-A80B-F66355C03A79 张孝南
可能是我没说清楚 我想要的结果是先以departmentid来排序 然后针对属于这个department的员工进行名字上的排序 不好意思 --------------------编程问答--------------------
select * from employee,department where employee.departmenrtid=department.id
order by departmenrtid sort asc,employee.name asc
补充:.NET技术 , ASP.NET