select e1.sname,e2.sname from emp e1,emp e2 where e1.sname 
= 'ram' 
and e2.sname = 'raj';

;with TEST as (select Row_Number() over (partition by sname 
order by sname) as ROWNO,sname from student)
select sname from TEST order by ROWNO,(case when sname 
= 'RAM' then 1
                             when sname = 'RAJ' then 2 end)

select (substring(name,1,3)+' '+substring(name,13,3)
+' '+substring(name,5,3)+' '+substring(name,17,3)
+' '+substring(name,9,3)+' '+substring(name,21,3))name
from employee where name like '%raj%'

--The query to work in SQL server 2000
declare @cnt int
select @cnt = count(sname) from student where sname ='ram'

declare @student table
(sname varchar(20))

while @cnt <> 0
begin
insert @student 
select * from student where sname like 'raj'
union
select * from student where sname like 'ram'
order by sname desc
set @cnt = @cnt - 1
End

select * from @student

select a.tnam,b.tnam from (select tnam from temp where tnam 
= 'Ram' ) a,
(select tnam from temp where tnam = 'Raj' ) b

select ename from (select Row_Number() over (partition by 
ename 
order by ename) as ROWNO,ename from emp) p
 order by ROWNO,ename desc

select sname from (select Row_Number() over (partition by 
sname 
order by sname) as ROWNO,sname from student) p
 order by ROWNO,sname desc


only change table name same as bobby