sql匹配查询排序

表A中有Address,Aname,Asex三个字段
insert into a values('上海','张三','男')
insert into a values('北京','李四','女')
insert into a values('深圳','王五','男')
insert into a values('上海','赵六','女')
insert into a values('北京','陈七','男')
insert into a values('上海','张三','男')
...
查询所有结果,地址最多的排第一，姓名排第二，性别第三，输出结果
Address Aname  Asex
上海    张三  男
上海    张三  男
上海    赵六  女
北京  ....
....


请教如何实现?

---

SQL code:
select Address,Aname,Asex
from 表A t
order by (select count(*) from 表A where Aname= t.Aname) desc,Aname

---

SQL code:
select *
from ta a
order by isnull((select count(*) from ta where Address=a.Address),0)desc,
isnull((select count(*) from ta where Aname=a.Aname),0)desc,
isnull((select count(*) from ta where Asex=a.Asex),0)desc

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www