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
Answer Posted / 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 |
Post New Answer View All Answers
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why do we backup Active Directory ?
What is query parameter in ssrs?
What are xml indexes?
What is a hint?
What is transaction server implicit?
Is sql different from sql server?
What command is used to create a database in the sql server and how?
What are points to remember while using the fillfactor argument?
What are different types of statements that are supported by sql?
What is the function of inner join?
What are joins in sql and what are the different types of joins?
Explain transaction server isolation?
How to change a login name in ms sql server?
What is the use of sql profiler in sql server 2012?