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 system databases into sql server (2005/2008)?

1000

How do I schedule a sql server profiler trace?

981

Explain what is sql server english query?

1052

What are the types of lock supported by ?

1046

How do I completely remove sql server instance?

1104

What do you understand by a stored procedure?

1088

Why use identity in sql server?

1106

What is primary key index?

980

What is 4nf in normalization form?

1026

what are constraints? : Sql server database administration

1057

How to delete an existing row with delete statements in ms sql server?

1093

What is logon trigger?

1098

what is hash nonclustered index

969

What are statistics?

1001

What is the beast way to write CTE in SQL Server ?

1046