i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
Answers were Sorted based on User's Feedback
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)
Is This Answer Correct ? | 9 Yes | 1 No |
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
Is This Answer Correct ? | 8 Yes | 0 No |
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
Is This Answer Correct ? | 3 Yes | 1 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mala
select a.tnam,b.tnam from (select tnam from temp where tnam
= 'Ram' ) a,
(select tnam from temp where tnam = 'Raj' ) b
Is This Answer Correct ? | 1 Yes | 2 No |
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%'
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / chitram
select e1.sname,e2.sname from emp e1,emp e2 where e1.sname
= 'ram'
and e2.sname = 'raj';
Is This Answer Correct ? | 3 Yes | 14 No |
Explain about temporary stored procedure?
what are the new features of sql server 2005?
8 Answers HP, Keane India Ltd,
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How you trouble shoot when any job fails
Explain the collation?
What are the types of joins in sql?
What is an sql server agent?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What do mean by xml datatype?
What is the difference between mysql and mysqli?
List few advantages of stored procedure.
how can do you the system monitoring?