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
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 |
Post New Answer View All Answers
What is dbcc?
Can we join two tables without primary key?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is shrink log file?
What is the difference between a check constraint and a rule?
What is the distinction amongst delete and truncate?
Tell me about builtinadministrator?
What is a full text index?
What do you mean by a Composite primary key?
What are commit and rollback in sql?
What is service broker?
Explain filestream storage of sql server 2008?
How do I manually uninstall an instance of sql server 2016?
List all types of constraints in sql server?