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
What triggers long term care?
Do you know the capabilities of cursors?
What is a matrix in ssrs?
What is the filtered index?
How can windows applications connect to sql servers via odbc?
What are the restrictions that views have to follow?
How to list all columns in a table using odbc_columns()?
what is datawarehouse?
How can I change procedure name in sql server?
What are the system database in sql server 2005?
What are the 10 characteristics of data quality?
What are pages and extents? : SQL Server Architecture
What are the types of table?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Why I have to use stored procedures?