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 dbcc?

1179

Can we join two tables without primary key?

1091

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1177

What is role playing dimension with two examples? : sql server analysis services, ssas

1052

What is shrink log file?

947

What is the difference between a check constraint and a rule?

1345

What is the distinction amongst delete and truncate?

1110

Tell me about builtinadministrator?

1041

What is a full text index?

964

What do you mean by a Composite primary key?

1183

What are commit and rollback in sql?

1168

What is service broker?

1058

Explain filestream storage of sql server 2008?

1073

How do I manually uninstall an instance of sql server 2016?

1074

List all types of constraints in sql server?

1086