mssqlÈ¥³ýÖظ´²¢ÅÅÐòµÄÎÊÌâ

SQL code:
/*
create database temp
use temp

create table employees
(
eID int identity primary key,
eName nvarchar(50) not null,
eSex smallint not null default(1),
eSort smallint default(0)
)

insert into employees values('a1',1,1);
insert into employees values('b5',0,5);
insert into employees values('a6',0,6);
insert into employees values('b3',1,3);

insert into employees values('a1',1,7);
insert into employees values('b5',0,9);
insert into employees values('a6',0,10);
insert into employees values('b3',1,20);
*/


ÏëµÃµ½ÕâôÑùµÄÒ»¸ö½á¹û£º£¨È¥³ýÖظ´µÄeName£¬²éѯ³öesort×î´óµÄ¼Ç¼¼¯£©
5 a1 1 7
6 b5 0 9
7 a6 0 10
8 b3 1 20

{{