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


Please Help Members By Posting Answers For Below Questions

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

547


can we have a nested transaction? : Sql server database administration

507


Explain cdc and sql injection?

549


How to transfer data from a cursor to variables with a "fetch" statement?

586


How can I tell if sql server is 32 or 64 bit?

501






Explain what is the difference between union and union all?

550


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1790


Do I need a report server to run reports in my application?

106


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

525


Explain transaction server consistency?

528


can an order by clause be used in a creation of a view?

697


What is database isolation in sql server? : sql server database administration

570


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

527


How to modify the underlying query of an existing view?

541


how would you troubleshoot blocking? : Sql server database administration

524