select e1.sname,e2.sname from emp e1,emp e2 where e1.sname = 'ram�

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

Question Posted / chitram

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

Please Help Members By Posting Answers For Below Questions

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1028

How can we get count of the number of records in a table?

940

How to create a user to access a database in ms sql server using "create user" statements?

937

What is xdr?

971

Where cross join is used?

936

How to use user defined functions in expressions?

1059

List the data types available in mssql?

1018

What is the difference between writing data to mirrored drives versus raid5 drives

903

What is onf in normalization form?

1035

What does the not null constraint do?

1061

What are page splits? : SQL Server Architecture

971

What is the difference between insensitive and scroll cursor?

1140

If a table does not have a unique index, can a cursor be opened on it?

898

What is PROJECTION Operation?

1005

What are data files?

1023