¹ØÓÚSQLµÄÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

Id Name Flag
1 ÕÅÈý 1  
2 ÍõÎå 3
3 ÕÅÈý 1
4 ÀîËÄ 2
5 ÕÅÈý 1
6 ÀîËÄ 2

ÎÒÏëÊä³öµÄʱºò±ä³ÉÕâÑù

Id Name Flag
1 ÕÅÈý 1  
3 ÕÅÈý 1
5 ÕÅÈý 1
4 ÀîËÄ 2
6 ÀîËÄ 2
2 ÍõÎå 2

SQLÈçºÎд£¿ 

×¢£ºÖ»·Ö×鲻ͳ¼Æ

---

SQL code:
select * from [TB] order by Flag



?

---

¼ÙÈçFlagÊÇÎı¾ÄØ £¿

---

ÒýÓÃ

¼ÙÈçFlagÊÇÎı¾ÄØ £¿

select * from tb order by cast(Flag as int)

---

o

---

SQL code:
--sinpoal

if object_id ('ta' ) is not null drop table ta
create table ta(id int ,[name] char(8), flag int)
insert into ta
select 1,'ÕÅÈý',1 union all
select 2,'ÍõÎå',3 union all
select 3,'ÕÅÈý',1 union all
select 4,'ÀîËÄ',2 union all
select 5,'ÕÅÈý',1 union all
select 6,'ÀîËÄ',2


select * from ta order by flag


/*-----------RESULT-----------
id name flag
1 ÕÅÈý 1
3 ÕÅÈý 1
5 ÕÅÈý 1
6 ÀîËÄ 2
4 ÀîËÄ 2
2 ÍõÎå 3
*/

---

SQL code

---

Code highlighting produced by