求一条SQL句子:

[jumin80]

有这么一个表:
id name sex grade
1 aa 1 69
2 aa2 2 69
3 aa3 2 50
4 aa4 1 89
5 aa5 2 77
6 aa6 1 75
7 aa7 1 50

等等这样的数据,数据量特别大,现在想统计这样的数据: (sex 表示性别: 1,男;2 女)

列出男的分数(grade)>=60,女的(grade)>=50 的人员名单,看有好的建议没?

[sheng9hhd]

where ([sex]=1 and grade>=60) or ([sex]=2 and grade>=50)

[hsabout]

select * from table where (sex='1' and grade>=60) or (sex='2' and grade>=50)
不知道ok否

[whoami333]

select name from tale1 where (sex=1 and grade>=60) or (sex=2 and grade>=50)

[shoushii]

SELECT id,name,(CASE sex WHEN 1 THEN '男' ELSE '女' END),grade FROM Table WHERE Sex=1 AND grade>=60
UNION ALL 
SELECT id,name,(CASE sex WHEN 1 THEN '男' ELSE '女' END),grade FROM Table WHERE Sex=2 AND grade>=50

[conan304]

declare @t table([id] int identity(1,1),[name] varchar(3),sex int,grade int)
insert @t([name],sex,grade) select 'aa',1,69 
union all select 'aa2',2,69 
union all select 'aa3',2,50 
union all select 'aa4',1,89 
union all select 'aa5',2,77 
union all select 'aa6',1,75 
union all select 'aa7',1,50

select * from @t
where grade>=60 or (sex=2 and grade>=50)

/*

（所影响的行数为 7 行）

id          name sex         grade       
----------- ---- ----------- ----------- 
1           aa   1           69
2           aa2  2           69
3           aa3  2           50
4           aa4  1           89
5           aa5  2           77
6           aa6  1           75

（所影响的行数为 6 行）
*/

[xiaojing7]

create Proc Proc_GetName
	@BoyPoint int,
	@GirlPoint int
as
begin transaction
	Declare @sql varchar(1024)
	set @sql='elect name as 名单 where 1=1 '

	if(@BoyPoint is not null)
	begin
		set @sql=@sql+'and sex=1 and grade>='+@BoyPoint
	end
	if(@GirlPoint is not null)
	begin
		set @sql=@sql='and sex=2 and grade>='+@GirlPoint
	end
exec(@sql)

if @@error <>0
begin
	rollback transaction
end
else
begin
	commit transaction
end

[Lakers_24号程序员]

[Quote=引用 6 楼 xiaojing7 的回复:]
SQL codecreate Proc Proc_GetName
@BoyPoint int,
@GirlPoint int
as
begin transaction
Declare @sql varchar(1024)
set @sql='elect name as 名单 where 1=1 '

if(@BoyPoint is not null)
begin
set @sql=@sql+'and sex=1 and grade>='+@BoyPoint
end
if(@GirlPoint is not null)
begin
set @sql=@sql='and sex=2 and grade>='+@GirlPoint
end
exe…

很好！顶一下！我也喜欢用存储过程！被你先了一步！
[/Quote]

[紫气东来_999]

[Quote=引用 4 楼 shoushii 的回复:]
SQL codeSELECT id,name,(CASE sex WHEN 1 THEN '男' ELSE '女' END),grade FROM Table WHERE Sex=1 AND grade>=60
UNION ALL
SELECT id,name,(CASE sex WHEN 1 THEN '男' ELSE '女' END),grade FROM Table WHERE Sex=2 AND grade>=50
[/Quote]

UNION 好过 OR

[jeff_wang]

如果是个常用操作，一定要建立Index on Sex