Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9
- 12 Answers
- 17820 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / guru
Union gives the result in two records
We have to use cross join like below
select * from table1,table2
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What are Row versions of DataRow?
Where can you add custom error messages to sql server?
What is cached report?
Which joins are sql server default?
Does index slows down insert statements?
What do you understand by check constraint in sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Can a database be shrunk to 0 bytes, if not, why?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Can you explain about buffer cash and log cache in sql server?
What is extent? Types of extents?
What is filtered index?
What is sql injection? How to protect against sql injection attack?
What is the stuff?
Explain the architecture of ms sql reporting service?
