一道sql笔试题

表t_bind(id,reg_no,bind_no)
一个注册号码reg_no只能有3个绑定号码,怎么得到如下的结果?
reg_no,bind_no1,bind_no2,bind_no3
075582203401 13584568752 15384866523 18984865266
......       ......      ......

--drop table t_bind;

create table t_bind(
	id int auto_increment primary key ,
	reg_no varchar(20),
	bind_no varchar(20)
);

insert into t_bind(reg_no,bind_no) values('075582203401','13584568752');
insert into t_bind(reg_no,bind_no) values('075582203401','18984865266');
insert into t_bind(reg_no,bind_no) values('075582203401','15384866523');
insert into t_bind(reg_no,bind_no) values('075582203402','15384866527');
insert into t_bind(reg_no,bind_no) values('075582203402','18984887525');

select m.reg_no, (select min(bind_no) from t_bind where reg_no=m.reg_no) bind_no1, (select min(bind_no) from t_bind where reg_no=m.reg_no and bind_no>(select min(bind_no) from t_bind where reg_no=m.reg_no)) bind_no2, (select max(bind_no) from t_bind where reg_no=m.reg_no and (select count(*) from t_bind  where reg_no=m.reg_no)>2) bind_no3 from t_bind as m group by m.reg_no;

执行结果:
+--------------+-------------+-------------+-------------+
| reg_no       | bind_no1    | bind_no2    | bind_no3    |
+--------------+-------------+-------------+-------------+
| 075582203401 | 13584568752 | 15384866523 | 18984865266 |
| 075582203402 | 15384866527 | 18984887525 | NULL        |
+--------------+-------------+-------------+-------------+
还有什么好的写法没?