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
How to use values from other tables in update statements in ms sql server?
Explain in details security in SQL azure?
How do I create a stored procedure in sql server?
What is right outer join in sql server joins?
How to delete existing rows in a table?
Write a sql query to get zero records from a table having n number of records?
What are the different SQL Server Versions you have worked on?
What is the full form of dql?
What stored procedure would you use to view lock information?
what are the three command line utilities and what are their primary functions?
what is isolation level at dead lock?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to remove duplicate rows from table?
List the various tools available for performance tuning?
What are subquery and its properties?