如何写SQL查询语句？

SELECT *
FROM emp
WHERE sal=800

SELECT *
FROM emp
WHERE sal=1000

select sal,ename from EMP
where sal=800 or sal=1000
结果是列状的不在一行。至于在一行怎么写，我也不太清楚。
结果应该是
sal ename
------------
800 SAM
800 TOM
800 MARY
1000 DAC
1000 ALLEN

select *from emp where sal=800 and sal=1000

这必须用存储过程了
我前几天也遇到了一个
你稍改一下就行了

ALTER procedure pro_a
as

declare cur1 cursor for select u.uid, u.name ,u.email from user1 u group by u.name,u.email,u.uid

select u.uid, u.name ,u.email,cast('deptname' as varchar(40)) deptname into #t from user1 u group by u.name,u.email,u.uid

open cur1
declare @uid int,@uname varchar(20),@email varchar(20)
fetch cur1 into @uid ,@uname,@email
while @@fetch_status=0
begin
declare @out varchar(20)
set @out=''
declare cur2 cursor for select p.name from user_part u