Answer / sagun sawant

;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)

Answer / bobby

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

Answer / shunmuga priya

--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

Answer / pradip jain

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

Answer / murthy

select e.name from
(select *,row_number() over (partition by name order by
name) as Rw from #T1) e
order by e.Rw,name desc

Answer / praveend

This query ill run on MySQL

CREATE TABLE IF NOT EXISTS `stu` (
`id` int(5) DEFAULT NULL,
`sname` varchar(20) DEFAULT NULL
)


INSERT INTO `stu` (`id`, `sname`) VALUES
(1, 'ram'),
(2, 'ram'),
(3, 'ram'),
(4, 'raj'),
(5, 'raj'),
(6, 'raj');

ANSWER
select sname from (
select (id- round((select count(*)from stu)/2)) as id, sname from stu where id >((select count(*)from stu)/2)
UNION
select * from stu where id<4
) as B order by(id)

Answer / mala

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

Answer / deepak rohilla

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%'

Answer / chitram

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

How to Insert multiple rows with a single insert statement?

0 Answers  

What samples and sample databases are provided by microsoft?

0 Answers  

Can we take the full database backup in log shipping?

0 Answers  

How to restore performance issues and how to check?

0 Answers  

What is mapping schema?

0 Answers  

Do you know what is a linked server in sql server?

0 Answers  

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

What are the different normalization forms?

0 Answers  

What are the OS services that the SQL Server installation adds?

3 Answers  

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

Explain Trigger with an example?

2 Answers  

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers