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

Characterize join and name diverse sorts of joins?

968

How to disable a login name in ms sql server?

1134

How to connect of datebase with sql express.?

1104

What is the contrast between sql and mysql?

1110

How can you append an identity column to a temporary table?

954

How to perform backup for certificates in sql server? : sql server security

1092

How to skip remaining statements in a loop block using continue statements?

998

What are the advantages of the mirroring?

1094

How to verify a user name with sqlcmd tool?

1080

What are magic tables in sql server?

1135

What are the advantages of mirroring?

995

Explain stored procedure?

1055

How to modify an existing stored procedure in ms sql server?

1079

What are the types of indexing?

1084

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944