一个sql查询的问题，望不吝赐教……

Question

一个会员表里，怎么查询，才能使查出的结果是一行男一行女一行男一行女一行男一行女…………

Answer 1

use tempdb 
go

declare @tb table(name nvarchar(20),sex nvarchar(10))
insert into @tb 
select '张三','男'
union all
select '李四','男'
union all
select '王五','男'
union all
select '赵六','女'
union all 
select '曹七','女'

select * from @tb

declare @newtb table(name nvarchar(20),sex nvarchar(10),ID int)
declare @tbman table(name nvarchar(20),sex nvarchar(10),ID int identity(1,2))
declare @tbwoman table(name nvarchar(20),sex nvarchar(10),ID int identity(2,2))

insert into @tbman select * from @tb where sex='男'
insert into @tbwoman select * from @tb where sex='女'
insert into @newtb
select * from @tbman 
union all
select * from @tbwoman 
order by ID

select * from @newtb