mysql
name age address
----------------------------------
zhangsan 2 ewr
lisi 7 wer
zhangsan 6 sdf
lisi 4 er
lisi 4 dsaf
如何按name分组查询，显示
name age address
----------------------------------
zhangsan 2 ewr
zhangsan 7 wer
lisi 6 sdf
lisi 4 er
lisi 4 dsaf
MySQL
[解决办法]
sql server的varchar是可以排序的，问题是如果mysql不行，为啥你不去mysql专区问呢？
----------------------------
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2013-08-20 18:24:39
-- Version:
-- Microsoft SQL Server 2014 (CTP1) - 11.0.9120.5 (X64)
--Jun 10 2013 20:09:10
--Copyright (c) Microsoft Corporation
--Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
--
----------------------------
--> 测试数据：[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([name] varchar(8),[age] int,[address] varchar(4))
insert [huang]
select 'zhangsan',2,'ewr' union all
select 'lisi',7,'wer' union all
select 'zhangsan',6,'sdf' union all
select 'lisi',4,'er' union all
select 'lisi',4,'dsaf'
--------------开始查询--------------------------
select * from [huang] ORDER BY NAME DESC
----------------结果----------------------------
/*
name age address
-------- ----------- -------
zhangsan 2 ewr
zhangsan 6 sdf
lisi 4 er
lisi 4 dsaf
lisi 7 wer
*/
