select a.tnam,b.tnam from (select tnam from temp where tnam = '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 / mala

Answer Posted / mala

select a.tnam,b.tnam from (select tnam from temp where tnam
= 'Ram' ) a,
(select tnam from temp where tnam = 'Raj' ) b

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is indexing in sql server with example?

983

how to create “alternate row colour”?

146

Explain the third normal form(3nf)?

923

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1019

How can I add Reporting Services reports to my application?

129

What is default port number for sql server 2000?

1025

What are the differences between union, intersect, and minus operators?

1064

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

983

what stored procedure can you use to display the current processes? : Sql server administration

994

Distinguish between nested subquery and correlated subquery?

1021

When would you use a before or after trigger?

892

What do you understand by integration services in sql server?

945

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

914

What is the use of keyword with encryption.

1015

What are the key configuration files for sql server reporting services ?

167