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

Do you know what is blocking?

901

What objects does the fn_my_permissions function reports on? : sql server security

993

What are different types of views?

893

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1046

Explain syntax for viewing, dropping and disabling triggers?

899

What is the use of keyword with encryption. Create a store procedure with encryption?

904

How to set a database state to offline in ms sql server?

968

What are pages and extents? : SQL Server Architecture

959

Explain log shipping?

960

What is parameterized reports in ssrs ?

141

What are partitioned views?

940

Can we perform backup restore operation on tempdb?

955

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

906

What is dirty read?

1041

Explain few examples of stored procedure over triggers?

964