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 / 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 |
Post New Answer View All Answers
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
can we have a nested transaction? : Sql server database administration
Explain cdc and sql injection?
How to transfer data from a cursor to variables with a "fetch" statement?
How can I tell if sql server is 32 or 64 bit?
Explain what is the difference between union and union all?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Do I need a report server to run reports in my application?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Explain transaction server consistency?
can an order by clause be used in a creation of a view?
What is database isolation in sql server? : sql server database administration
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to modify the underlying query of an existing view?
how would you troubleshoot blocking? : Sql server database administration