求SQL语句 - MS-SQL Server / 基础类

TableA

id name math eng chinese  
1 aaa 100 99 88
2 bbb 65 60 67
3 ccc 110 99 70
4 ddd 77 89 78


如何求出成绩含有99的学生(尽量不要写每个字段）

---

SQL code:
select distinct name
from
(
select name，math from TableA
union all
select name，eng from TableA
union all
select name，chinese from TableA
) tt
where math>99

---

SQL code:
create table #TT
(
id int identity(1,1) primary key,
name nvarchar(50),
math int,
eng int,
chinese int
)
insert into #TT select 'aaa',100,99,88
insert into #TT select 'bbb',65,60,67
insert into #TT select 'ccc',110,99,70
insert into #TT select 'ddd',77,89,78


select distinct name
from
(
select name,math from #TT
union all
select name,eng from #TT
union all
select name,chinese from #TT
) tt
where math=99
name
--------------------------------------------------
aaa
ccc

(2 行受影响)

---

SQL code:
--------------------------------------------------------------------------
-- Author : h