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

1240

What is the full form of dql?

1028

What are tables in sql server?

1098

Explain aggregate functions?

1141

What are group functions in query statements in ms sql server?

1066

Does a sql server 2005 select statement require a from?

1073

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1087

What are the purpose of Normalisation?

1097

What is the command to change the recovery model?

1093

which backup strategy you are following at ur company

2195

Explain nested join?

1036

How can we solve concurrency problems?

1098

What are page splits?

1054

What is difference in performance between insert top (n) into table and using top with insert?

1122

What is the difference between SQL notification and SQL invalidation?

1267